#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default Charts

Hi all,

I have a sheet with charts that works well,but i have a problem,if the
value entered in the source data is NULL,the chart displays it as if it were
0,i tried to change the frormat of the source data cells to number or
general,but i always get the same result..can anybody help ???
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Charts

Replace your NULL by =NA().
--
David Biddulph

"Pietro" wrote in message
...
Hi all,

I have a sheet with charts that works well,but i have a problem,if the
value entered in the source data is NULL,the chart displays it as if it
were
0,i tried to change the frormat of the source data cells to number or
general,but i always get the same result..can anybody help ???



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default Charts

Could you please more clear ?
Thanx

"David Biddulph" wrote:

Replace your NULL by =NA().
--
David Biddulph

"Pietro" wrote in message
...
Hi all,

I have a sheet with charts that works well,but i have a problem,if the
value entered in the source data is NULL,the chart displays it as if it
were
0,i tried to change the frormat of the source data cells to number or
general,but i always get the same result..can anybody help ???




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Charts

If you have a formula that currently says =IF(A1=0,"",A1), then replace this
by =IF(A1=0,NA(),A1).
--
David Biddulph

"Pietro" wrote in message
...
Could you please more clear ?
Thanx

"David Biddulph" wrote:

Replace your NULL by =NA().
--
David Biddulph

"Pietro" wrote in message
...
Hi all,

I have a sheet with charts that works well,but i have a problem,if
the
value entered in the source data is NULL,the chart displays it as if it
were
0,i tried to change the frormat of the source data cells to number or
general,but i always get the same result..can anybody help ???






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default Charts

I don't have any formula like this ,but the cells that combine the the data
source of the chart are linked to other cells in other tab,and these ones as
well don't have this formula..

"David Biddulph" wrote:

If you have a formula that currently says =IF(A1=0,"",A1), then replace this
by =IF(A1=0,NA(),A1).
--
David Biddulph

"Pietro" wrote in message
...
Could you please more clear ?
Thanx

"David Biddulph" wrote:

Replace your NULL by =NA().
--
David Biddulph

"Pietro" wrote in message
...
Hi all,

I have a sheet with charts that works well,but i have a problem,if
the
value entered in the source data is NULL,the chart displays it as if it
were
0,i tried to change the frormat of the source data cells to number or
general,but i always get the same result..can anybody help ???








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Charts

If you still want help, you may need to make it clearer how your NULL values
appear.
--
David Biddulph

"Pietro" wrote in message
...
I don't have any formula like this ,but the cells that combine the the data
source of the chart are linked to other cells in other tab,and these ones
as
well don't have this formula..


"David Biddulph" wrote:

If you have a formula that currently says =IF(A1=0,"",A1), then replace
this
by =IF(A1=0,NA(),A1).


"Pietro" wrote in message
...
Could you please more clear ?


"David Biddulph" wrote:

Replace your NULL by =NA().


"Pietro" wrote in message
...
Hi all,

I have a sheet with charts that works well,but i have a problem,if
the
value entered in the source data is NULL,the chart displays it as if
it
were
0,i tried to change the frormat of the source data cells to number
or
general,but i always get the same result..can anybody help ???



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
interactive charts for stacked bar charts [email protected] Charts and Charting in Excel 4 December 28th 06 10:58 PM
Combine Clustered Column Bar charts and Stacked column bar charts Richard Charts and Charting in Excel 1 October 26th 06 03:44 AM
Pie Charts welshygunner Charts and Charting in Excel 1 July 3rd 06 03:02 PM
3D Pie Charts Rachel Charts and Charting in Excel 3 June 30th 06 02:50 AM
Matching the colors Column Charts and Pie Charts RohanSewgobind Charts and Charting in Excel 3 April 21st 06 10:35 PM


All times are GMT +1. The time now is 03:41 PM.

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

About Us

"It's about Microsoft Excel"