top bar in bar chart

D

DonnaO

When creating a bar chart (default style) in Excel 2003, I occasionally find
that part of the top bar disappears off the top of the plot area. I'm
unaware of doing anything to cause this. This results in the top bar being
shallower than the others. Any ideas please?
 
D

Del Cotter

When creating a bar chart (default style) in Excel 2003, I occasionally find
that part of the top bar disappears off the top of the plot area. I'm
unaware of doing anything to cause this. This results in the top bar being
shallower than the others. Any ideas please?
Click to expand...

Try going into the "Format Axis" dialogue for the Category (X) axis and
checking the box labelled "Value (Y) axis crosses between categories".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove title bar and phase bar by default on swimlane 0
Convert Error Bars to Series and Colour 1
Average bar charts with individual data points 2
sideways stacked bar charts with line series on the same axis 0
Odd chart type needed 1
Invert bar chart content but not the axes 1
Move x axis to the top of a 3D horizontal bar chart 1
Bar and Line plots on the same chart 2

Top