Negative values on Y axis

D

DruD

working on a bar chart. Data source contains NO negative values. When
viewing chart in print preview, Y axis shows value of -100. How can I
eliminate this? And why is it there in the first place if there are no
negative values in the data source?
 
A

Andy Pope

Hi,

Check the min value of the Y axis.
Double click the Y axis to display the Format dialog.
On the Scale tab check whether the Minimum scale is set to Auto or
specified value.
If Auto then there must be something the chart that is causing this.
Are there other data series in the chart, maybe with no formatting.
Maybe Error bars or trend line.

Cheers
Andy
 

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

Display Negative Time Values on Y-Axis 0
Positioning x axis at bottom of chart with negative values 5
One extra x axis item that wont go away - can anyone help? 3
Negative values on X axis 6
Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Data labels along below x axis when y axis has negative values 1
Stack bar charts with positive and negative numbers 2

Top