Making a template with logarithmic chart

[Rick Flaherty]

I'm working on a template to analyze stock data. I want
to enter data and chart it on a logrithimic y axis. I
guess Excel assumes that all empty cells are either 0 or
a negative number because when I start to enter data a
message appears and tells me that you can't chart 0 or
negative numbers in a logrithimic chart. If I could enter
the data it wouldn't be 0 or negative.
How can I make a template that allows you to enter the
data before it determines the data is in error.
Thanks,
RickF

 

[Martin Brown]

I'm working on a template to analyze stock data. I want
to enter data and chart it on a logrithimic y axis. I
guess Excel assumes that all empty cells are either 0 or
a negative number because when I start to enter data a
message appears and tells me that you can't chart 0 or
negative numbers in a logrithimic chart. If I could enter
the data it wouldn't be 0 or negative.

That has to be one of Excels most irritating error messages. And it is
rather fickle about how and when it gives it. There are different kinds
of "empty" cell that superficially look the same on the screen - ISTR
those containing empty strings or spaces cause this msg.

I only have the problem you describe with log charts XL2k iff I put some
space characters or 0 data into the array being plotted.

How can I make a template that allows you to enter the
data before it determines the data is in error.

Try forcing the minimum Y scale to manual value of 1 and make sure that
the contents of every data cell in the range being plotted
logarithmically is deleted. A blank text entry or null string will
elicit the error msg.

All cells in your plot range should give ISBLANK( ) = TRUE

Reading in raw data you have to explicitly delete any zero value data if
it is destined for a log plot before the chart is created.

Regards,

 

[Tushar Mehta]

The answer hasn't changed since you asked the question 10 days ago. See
http://www.google.com/groups?selm=MPG.19eaba41a111e40198aceb%
40msnews.microsoft.com
--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office