| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problem 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. -- MJ |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Charting Null Values
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Charting Null Values
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Charting Null Values
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 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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Charting Null Values
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. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Charting Null Values
It's just that some URLs are not very user-friendly, such as:
http://groups.google.co.uk/group/mic...2a5ee42b13cc85 or http://groups.google.com/group/micro...2a5ee42b13cc85 or much worse. I agree, however, that http://pubs.logicalexpressions.com/P...?ID=209#jon020 could have been posted as it stands. -- David Biddulph "Jon Peltier" wrote in message ... 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. |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Charting Null Values
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 ... It's just that some URLs are not very user-friendly, such as: http://groups.google.co.uk/group/mic...2a5ee42b13cc85 or http://groups.google.com/group/micro...2a5ee42b13cc85 or much worse. I agree, however, that http://pubs.logicalexpressions.com/P...?ID=209#jon020 could have been posted as it stands. -- David Biddulph "Jon Peltier" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting null values | Charts and Charting in Excel | |||
| excell charting problem with false values | Charts and Charting in Excel | |||
| How do you stop excel from charting empty cells/null values as zer | Charts and Charting in Excel | |||
| CountIf & null values problem | Excel Worksheet Functions | |||
| Charting should not plot NULL as a zero | Charts and Charting in Excel | |||
Linear Mode
