Negative values on Y axis

  • Thread starter Thread starter DruD
  • Start date Start date
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?
 
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
 
Back
Top