Does anyone know how I can possibly create a graph exactly like this one in excel? It's Figure 9 on this paper (https://www.mdpi.com/1999-4923/12/12/1132/htm)
I am totally lost. I've tried and lost hours on excel, but I just can't seem to figure out how I should input my data since it's so complex...
Any help would be greatly appreciated!
I assume this is the chart you're talking about (if it isn't, please put the chart into your question):
This is quite easy to do in Excel, and it looks like it has been done in Excel.
It's a combined stacked column chart with a line chart.
The column chart has four series, as does the line chart. The easiest way to chart this is to lay out the data source to have one column for each series.
Lay out the data in a grid with a column for each of the eight series and all the X axis labels in the first column. Then insert a chart, for e.g. a stacked bar chart. The X axis values are numbers so you need to make sure Excel does not interpret these as another data series. To do that, make sure the cell above the column is blank. After the chart has been created, you can put the text back into that cell. I you want to use a hierarchical axis, then you will have two columns
Next, change the chart type to Combo. Make sure the first four series are Stacked Column, (not Clustered). Make the last four series Line and tick the secondary axis box.
For the hierarchical axis, make sure the hierarchy levels are in the worksheet. I had already taken the screenshots, so I inserted column A as an afterthought. Then edit the data source and click the button to edit the horizontal axis labels.
Change the range that the axis refers to to include two columns, not just one.
The rest is formatting. Change the colours, add markers to the line, add error bars.
You need to select each series one after the other, then click the + button and add the error bars.
The legend is a bit trickier to achieve. It looks like it has been put together with the drawing tools and the image superimposed onto the chart.
