Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ???
 
If you have a formula that currently says =IF(A1=0,"",A1), then replace this
by =IF(A1=0,NA(),A1).
 
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..
 
If you still want help, you may need to make it clearer how your NULL values
appear.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Charts 3
Copy chart with reference table 1
Expand Chart Source with New Row(s) 1
Excel2000: Weird chart behaviour 2
Chart 2
Copying Sheet with Pivot charts 3
Sheet Names Randomly Change (Chart Sheets Only) 1
Org Charts 1

Back
Top