Display zero on bar chart
Hello,
I am trying to set up a simple 3d bar chart for a student doing a traffic survey. His data is something like: car = 10, bike = 3, lorry = 0, motorbike = 2. The chart is easy to create but we want to display the zero for lorry. At the moment it just leaves a blank bar. I understand why it's blank but is there any way to specify that we want the base of the bar to show up. In Excel a bar chart which has a zero in it still has the base of the bar shaded, even though it doesn't rise up like the bars around it. I know this may only be an aesthetic wish but he wants it. Is this possible?
Thanks
Dan
I am trying to set up a simple 3d bar chart for a student doing a traffic survey. His data is something like: car = 10, bike = 3, lorry = 0, motorbike = 2. The chart is easy to create but we want to display the zero for lorry. At the moment it just leaves a blank bar. I understand why it's blank but is there any way to specify that we want the base of the bar to show up. In Excel a bar chart which has a zero in it still has the base of the bar shaded, even though it doesn't rise up like the bars around it. I know this may only be an aesthetic wish but he wants it. Is this possible?
Thanks
Dan
Macbook Pro, Mac OS X (10.6.6)
