I have a stacked bar chart (with primary and secondary axis) that is charting 9 sets of data - one being the total. The total of the data is set to chart in the primary axis behind the other 8 sets of data stacked in a bar chart. The range on the chart is - 20 to 220.
The data is (64,-13,181,18,29,6,12,32,34). The problem I have here is that the chart is not wanting to show the -13 bar below the 0 base line. For some odd reason it is starting all bar charts at the 20 mark instead of 0. If the bars would start charting at 0 I would have it done.
What I need is for the bar charting to begin at 0 for the 8 sets of values - which would allow the negative -13 to be below 0.
I have never had this done before - see attached.
THX
Bookmarks