How do I stop chart from plotting null values as zeros in excel 20
Blank (null) values plot as zeros in my charts. In excel 2003 I used
tools-options-active chart-plot empty cells as but I can't figure out how to do this in excel 2007. |
How do I stop chart from plotting null values as zeros in excel 20
On the Chart Tools Design tab, click on Select Data, then click the Hidden
and Empty Cells button on the dialog (bottom left corner). Note that this only works for true blank cells, not for formulas which return "". This is not a blank, but a short piece of text, which Excel evaluates as zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "suebee" wrote in message ... Blank (null) values plot as zeros in my charts. In excel 2003 I used tools-options-active chart-plot empty cells as but I can't figure out how to do this in excel 2007. |
How do I stop chart from plotting null values as zeros in exce
also if u have formulas u can return NA(). excel won't plot it. when u do
this u might want to change ur chart type to force excel to pick the new NA() "Jon Peltier" wrote: On the Chart Tools Design tab, click on Select Data, then click the Hidden and Empty Cells button on the dialog (bottom left corner). Note that this only works for true blank cells, not for formulas which return "". This is not a blank, but a short piece of text, which Excel evaluates as zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "suebee" wrote in message ... Blank (null) values plot as zeros in my charts. In excel 2003 I used tools-options-active chart-plot empty cells as but I can't figure out how to do this in excel 2007. |
How do I stop chart from plotting null values as zeros in exce
You solved part of my problem.
But if I've got a chart plotting cell A1 that says: =IF(ISBLANK(K13),na(),K13) Thanks to vaz, my chart won't plot anything if K13 is blank, but my cell A1 now says "#NA". Any way to make my cell plot nothing and show nothing? Just to make it look neater? "vaz" wrote: also if u have formulas u can return NA(). excel won't plot it. when u do this u might want to change ur chart type to force excel to pick the new NA() "Jon Peltier" wrote: On the Chart Tools Design tab, click on Select Data, then click the Hidden and Empty Cells button on the dialog (bottom left corner). Note that this only works for true blank cells, not for formulas which return "". This is not a blank, but a short piece of text, which Excel evaluates as zero. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "suebee" wrote in message ... Blank (null) values plot as zeros in my charts. In excel 2003 I used tools-options-active chart-plot empty cells as but I can't figure out how to do this in excel 2007. |
All times are GMT +1. The time now is 07:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com