Problem with Y-axis values in Chart in Excel 2000

  • Thread starter Thread starter Christophe
  • Start date Start date
C

Christophe

I have an excel workbook with several data sheets and 5 chart-sheets.
All of these charts get there data from the same sheet and everything
works fine. But when I try to make another chart-sheet with data from
that same data-sheet the Y-axis values are all 0 instead of for
example 552000. And the scale is 0 to 1 in steps of 0,1 while all data
is 200000-600000.
This only happens if the data is on line 69 or higher(in the data
sheet), everything from line 1 to line 68 does not give problems.

Is this a known problem or has anyone encountered something like this
before?
It's got nothing to do with cell formatting, already checked all of
that.
 
Christophe -

What is in the cells in row 69 and higher? If you have any text, Excel will get
confused and treat all of the data range as text, which means as zeros. When
plotting only zeros, the axis scale defaults to 0-1.

Do the cells look blank, because a formula returns a null string ("")? This is text,
not blank, and induces the aforementioned behavior in Excel. Replace the null string
with NA(), which returns the #N/A error. This is ugly in the sheet, but does not
plot in the chart; use conditional formatting to hide the errors, as described by
Debra Dalgleish on her web site:

http://contextures.com/xlCondFormat03.html#Errors

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top