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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

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

Surpressing plot of blank cells 3
How do I stop chart from plotting null values as zeros in excel 20 3
NA in Line chart plotting as zero 3
How do I disable "Plot visible cells only" when it is greyed out? 1
How do I plot "" as empty rather than zero in a chart 1
How do I not plot zero values that result from a formula in Excel? 1
Blank instead of "" 5
I don't want to graph "null" values? 1

Back
Top