Negative values on Y axis
 

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

Negative values on Y axis
 

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

DruD wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info