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

D

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
 
J

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Surpressing plot of blank cells 4
Plotting NA() or #N/A data points 1
Data points in chart incorrect 0
NA in Line chart plotting as zero 3
How do I disable "Plot visible cells only" when it is greyed out? 1
Blank instead of "" 5
Chart Plot Area changes in Excel 2007 0

Top