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

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

Use #N/A instead of text.

Jerry

Dozier wrote:

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

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.

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.

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.