Problem with Charting Null Values

MJ

unread,

Jul 29, 2008, 12:37:06 PM7/29/08

to

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.

--

MJ

Infinitogool

unread,

Jul 29, 2008, 5:27:21 PM7/29/08

to

Hi MJ

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

Regards,
Pedro J.

Jon Peltier

unread,

Jul 29, 2008, 6:12:22 PM7/29/08

to

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" <infini...@gmail.com> wrote in message
news:%23j1MiHc...@TK2MSFTNGP02.phx.gbl...

Infinitogool

unread,

Jul 29, 2008, 7:06:48 PM7/29/08

to

Hi Jon

ok

Pedro J.

David Biddulph

unread,

Jul 30, 2008, 4:07:01 AM7/30/08

to

Or use the Preview facility in tinyurl.
--
David Biddulph

"Jon Peltier" <jonxl...@SPAMpeltiertech.com> wrote in message
news:Oejs0gc8...@TK2MSFTNGP06.phx.gbl...

Jon Peltier

unread,

Jul 30, 2008, 12:44:33 PM7/30/08

to

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
news:Y7WdnTrhouO3vA3V...@bt.com...

David Biddulph

unread,

Jul 30, 2008, 1:19:23 PM7/30/08

to

It's just that some URLs are not very user-friendly, such as:
http://groups.google.co.uk/group/microsoft.public.excel.charting/browse_frm/thread/f19505c8c824c1e1/632a5ee42b13cc85?lnk=st&q=%22posting+a+tiny+url+is+a+great+help%22#632a5ee42b13cc85
or
http://groups.google.com/group/microsoft.public.excel.charting/browse_thread/thread/f19505c8c824c1e1/632a5ee42b13cc85#632a5ee42b13cc85
or much worse.

I agree, however, that
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon020
could have been posted as it stands.
--
David Biddulph

"Jon Peltier" <jonxl...@SPAMpeltiertech.com> wrote in message

news:%23gGlUOm...@TK2MSFTNGP03.phx.gbl...

Jon Peltier

unread,

Jul 30, 2008, 4:45:39 PM7/30/08

to

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
-------
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

news:48909e73$1...@glkas0286.greenlnk.net...