| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| interactive charts for stacked bar charts | Charts and Charting in Excel | |||
| Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
| Pie Charts | Charts and Charting in Excel | |||
| 3D Pie Charts | Charts and Charting in Excel | |||
| Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Linear Mode
