negative numbers in bar charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

W. Michael Kelly - 14 Aug 2003 21:28 GMT

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?

Reply to this Message

Max - 15 Aug 2003 04:02 GMT

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

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

Reply to this Message