View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Problem with Charting Null Values

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Or use the Preview facility in tinyurl.
--
David Biddulph

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Infinitogool" wrote in message
...
Hi MJ

See if the article at
http://tinyurl.com/67xc5s
does what you want.

Regards,
Pedro J.

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.