How do I stop plotted data from going to zero in a line chart?

[Dozier]

Text in cells are plotted as zeros in Excel 2003 with Windows XP.

[Jerry W. Lewis]

Use #N/A instead of text.

Jerry

Dozier wrote:

> Text in cells are plotted as zeros in Excel 2003 with Windows XP.

[Dozier]

I have multiple columns and enter tradiing (commodity) date daily. Formulae
are in the columns which become values when the daily data is entered. I
have been using Lotus and am trying with difficulty to convert to Excel

"Dozier" wrote:

> Text in cells are plotted as zeros in Excel 2003 with Windows XP.

[Jerry W. Lewis]

Formulas must return sumething (Excel has no missing or empty cell
value). Anything other than a number or a #N/A will plot as zero.
Either write an event driven macro to add the formula only when the data
is available, or else use a formula like
=IF(INUMBER(dailyData),formula,#N/A)
as I suggested yesterday. You can use a conditional format to hide the
display of error values in the cells if the worsksheet appearance
bothers you.

Jerry

Dozier wrote:

> I have multiple columns and enter tradiing (commodity) date daily. Formulae
> are in the columns which become values when the daily data is entered. I
> have been using Lotus and am trying with difficulty to convert to Excel
>
> "Dozier" wrote:
>
>
>>Text in cells are plotted as zeros in Excel 2003 with Windows XP.

[Dozier]

Thank you. However I must be doing somethng wrong and I just foound it. I had
not copied the formulae to the end of the date. All is well. The work
appearance does not bother me. Thanks

Dozier

"Jerry W. Lewis" wrote:

> Formulas must return sumething (Excel has no missing or empty cell
> value). Anything other than a number or a #N/A will plot as zero.
> Either write an event driven macro to add the formula only when the data
> is available, or else use a formula like
> =IF(INUMBER(dailyData),formula,#N/A)
> as I suggested yesterday. You can use a conditional format to hide the
> display of error values in the cells if the worsksheet appearance
> bothers you.
>
> Jerry
>
> Dozier wrote:
>
> > I have multiple columns and enter tradiing (commodity) date daily. Formulae
> > are in the columns which become values when the daily data is entered. I
> > have been using Lotus and am trying with difficulty to convert to Excel
> >
> > "Dozier" wrote:
> >
> >
> >>Text in cells are plotted as zeros in Excel 2003 with Windows XP.
>
>