Charting Negative with Bar Charts

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

Hi gacollege

You are only displaying the primary value axis. If you display also the secondary value axis you'll see that they do not span the same range of values. That's why you don't get the effect you want.

What you have

Primary value axis: from -20 to 230
Secondary value axis: from -50 to 250

This is why it seems wrong.

Do the following:

- Right click on the secondary value axis (or select it in the chart toolbar)
- choose Scale
- uncheck Automatic for Minimum and Maximum
- set minimum to -20
- set maximum to 230

Also uncheck the Automatic in the Primary value axis, leave the values -20 and 230.

WOW!!!!!!!!!!! I feel so stupid at the moment. Something so simple was a easy fix. If I were to have had the second axis displayed instead of hidden - I would have caught this. I kind of could not fix what I did not see on the screen and I forgot about the range for the second axis.

THANKS AGAIN!!!!!!!!!!!!!!!!!

Originally Posted by lecxe

Hi gacollege

You are only displaying the primary value axis. If you display also the secondary value axis you'll see that they do not span the same range of values. That's why you don't get the effect you want.

What you have

Primary value axis: from -20 to 230
Secondary value axis: from -50 to 250

This is why it seems wrong.

Do the following:

- Right click on the secondary value axis (or select it in the chart toolbar)
- choose Scale
- uncheck Automatic for Minimum and Maximum
- set minimum to -20
- set maximum to 230

Also uncheck the Automatic in the Primary value axis, leave the values -20 and 230.