 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / July 2008Problem with Charting Null Values
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.  SignatureMJ 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. [quoted text clipped - 8 lines] > > Thank you in advance for your input and expertise. 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 _______ > Hi MJ > [quoted text clipped - 17 lines] >> >> Thank you in advance for your input and expertise. Hi Jon ok Pedro J. > 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 [quoted text clipped - 5 lines] > Tutorials and Custom Solutions > Peltier Technical Services, Inc. - http://PeltierTech.com Or use the Preview facility in tinyurl. SignatureDavid Biddulph > 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 [quoted text clipped - 28 lines] >>> >>> Thank you in advance for your input and expertise. 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 _______ > Or use the Preview facility in tinyurl. >> You wouldn't mind posting the entire URL next time, would you? I know it [quoted text clipped - 29 lines] >>>> >>>> Thank you in advance for your input and expertise. 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/thre ad/f19505c8c824c1e1/632a5ee42b13cc85?lnk=st&q=%22posting+a+tiny+url+is+a+great+h elp%22#632a5ee42b13cc85 or http://groups.google.com/group/microsoft.public.excel.charting/browse_thread/thr ead/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. SignatureDavid Biddulph > 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 [quoted text clipped - 40 lines] >>>>> >>>>> Thank you in advance for your input and expertise. 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 _______ > 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/thre ad/f19505c8c824c1e1/632a5ee42b13cc85?lnk=st&q=%22posting+a+tiny+url+is+a+great+h elp%22#632a5ee42b13cc85 [quoted text clipped - 50 lines] >>>>>> >>>>>> Thank you in advance for your input and expertise. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.