Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 19th 07, 06:13 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 2
Default 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.

  #2   Report Post  
Old November 19th 07, 06:25 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default 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.



  #3   Report Post  
Old June 20th 08, 10:00 PM posted to microsoft.public.excel.charting
vaz vaz is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1
Default 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.




  #4   Report Post  
Old September 5th 08, 06:33 PM posted to microsoft.public.excel.charting
RNW RNW is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 4
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Pasted from One Worksheet Converts Null Values to Zeros BK Waas Excel Discussion (Misc queries) 0 November 22nd 06 06:21 PM
Unwanted Zeros in Excel Chart Displayed Values Daniel Compton Excel Discussion (Misc queries) 4 April 25th 06 04:07 PM
How do you stop excel from charting empty cells/null values as zer Abe-air Charts and Charting in Excel 3 March 21st 06 12:57 AM
Problem with plotting a chart when using arrays as Values and Xvalues [email protected] Charts and Charting in Excel 3 August 19th 05 09:05 PM
How to stop excel from plotting a "blank" cell with formula as zer tiw Excel Discussion (Misc queries) 5 April 21st 05 08:38 PM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017