negative numbers in bar charts

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?
 
M

Max

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
 

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

Top