negative numbers in bar charts

  • Thread starter Thread starter W. Michael Kelly
  • Start date Start date
W

W. Michael Kelly

Whenever my data contains negative numbers, the titles
appear at the "0" line while the bars extend below,
through the titles making them difficult to read.
How do I set the bottom of the chart so the titles appear
at the bottom instead of at the "0" line?
 
Right-click on the vertical axis>select Format Axis
Select Scale tab
Change the "0" under "Category (X) axis Crosses at:" box to a
value lower than the highest negative value, say: -50 (if the
highest negative is -10)
Click OK.

Optional: Format the plot area colour to None for a clearer look
 
Back
Top