Spread sheet charts

[Poppi]

Since upgrading to Office 365 I haVE a problem with some (not all) spread sheet charts. I frequently use IF formulae that return a zero value. An example is +IF(A22>0,B22/(A22-A$3),0) so if column A is a date and the date is > zero it completes the equation and posts the result but if column A is empty the result is zero. I further have the workbook programmed to not show zeroes. When I create a chart from those data the line plots normally up tp where the zeroes start then plunges to zero. As stated this is not universally true but does happen in a lot of my work. I have searched everywhere for a solution but nothing works. Suggestions will be appreciated

Thank

poppi

[MrShorty]

Some samples of the desired and undesired behavior might be helpful to describe the issue.

From what I have seen, Jon Peltier has the most thorough understanding of this kind of issue. Here's one of his recent tutorials: https://peltiertech.com/plot-blank-c...-excel-charts/ For a long time, the best way to have Excel not include a data point in a chart that is determined by formula is to have the formula return the N/A error when you want the chart to ignore the entry. You might try that instead of having the formula return 0.

[Poppi]

I have tried the NA() fix and it makes no difference. It still rerturnms zero to the chart . I have also tried adding two very similar spread sheets one of which has the problem and one which does not but I am unable to attach them. I KNOW I AM DOINMG SOMETHING WRONG THERE

POPPI

[MrShorty]

Are you able and/or willing to upload a sample file to the forum?

[Poppi]

Yes I have two samples to upload but I can't figure out how to do it. I went through all the steps but I am apparently doing something wrong

poppi

[MrShorty]

The instructions in the yellow banner at the top of the page have always worked for me. Are you clicking on "Go advanced" beneath the quick reply window to bring up the full editor? Then click on "Manage attachments" to bring up the attachment tab/window? Then add your attachment there. Compose a reply in the main editor tab/window and submit reply?

[RaulSerg]

What chart type are you using?
e.g. a line chart would not show NA() while a stacked line chart would (creating that plunging to zero thing).

[Poppi]

What chart type are you using?
e.g. a line chart would not show NA() while a stacked line chart would (creating that plunging to zero thing).

To answer your question the charts are all line charts. Meanwhile I am struggling to upload two charts, both ver similar, one of which has the problem the other no problem. I need to figure out how to attach them to a message

poppi

[Poppi]

I have tried your suggestions and selected two files and then clicked up load but they did not go to my reply message. What am I missing?

Thank you
poppi

[MrShorty]

No idea.

Here's a quick sample I put together using N/A where the date field hasn't yet been populated.