Please could someone help me with some chart configuration?
I have created a stacked bar chart that shows project stage data in the style of a gantt chart. I wanted the x axis labels to be dates (the end of each month to be precise), but found I was limited using the x axis itself in that I could only set a fixed interval between the values.
So, I removed the x axis and the gridlines, and added a new series of data with vertical error bars to replace the gridlines with the appropriate formatting etc.
It all works, except the error bars appear on top of the original stacked bar data, whereas I would prefer them to be underneath, like typical gridlines would be.
I have changed the series order by moving my new x-axis series to the very top of the list in the 'select data' view, but the bars are still on top of the stacked bar data.
Any advice would be greatly appreciated.
Bookmarks