Problem with Charting Null Values

M

MJ

I had several charts that I have around for a long time which worked
famously. When the dataset values were NULL (not ZERO) the line stopped.
This is what I want to happen.

Recently I made some minor changes in the chart size and position on the
worksheet, but did NOT alter the data source or chart type. Now when the
dataset values are NULL the chart treats them as ZEROs and the trace goes to
zero instead of just stopping.

What do I need to do to "correct" this?

Thank you in advance for your input and expertise.
 
J

Jon Peltier

You wouldn't mind posting the entire URL next time, would you? I know it
seems that posting a tiny url is a great help, but it's not. We have no idea
where it's pointing until after clicking the link.

- Jon
 
J

Jon Peltier

So someone must click on the link and switch to the browser, rather than
just being able to see the full link? That isn't the kind of philosophy one
should follow when interacting with people, designing interfaces, etc.

- Jon
 
J

Jon Peltier

I can see both of those fine in my newsreader, and my newsreader recognizes
the entire length as the URL, so the length doesn't bother me. I at least
can tell that they come from Google Groups, even if I can't decipher all the
codes.

- Jon
 

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

Charting null values 4
Charting blanks as spaces 1
Displaying zero values as gap in a chart 1
How do I stop chart from plotting null values as zeros in excel 20 3
How do you stop excel from charting empty cells/null values as zer 3
Charting with missing data or empty strings from vlookup() 2
#N/A 1
Not Charting Zero Values 1

Top