Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data
Source Data
I have the following data A B C D 1 1 2 2 2 3 3 3 6 4 0 0 5 0 0 Source Data is =Sheet1!$A$1:$b$5 When I am making the Chart I dont wont 0 to be part of the chart and I dont want to change the Source data range Can any one help with this |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data
Hi,
How is the zero derived? If it's as a result of a formula make the formula return NA instead of zero and Excel won't chart it. Fir example IF(C2=1,C2,NA()) Mike "osaka78" wrote: Source Data I have the following data A B C D 1 1 2 2 2 3 3 3 6 4 0 0 5 0 0 Source Data is =Sheet1!$A$1:$b$5 When I am making the Chart I dont wont 0 to be part of the chart and I dont want to change the Source data range Can any one help with this |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data
yes it's as a result of formula , it does't work Zero is charted still
"Mike H" wrote: Hi, How is the zero derived? If it's as a result of a formula make the formula return NA instead of zero and Excel won't chart it. Fir example IF(C2=1,C2,NA()) Mike "osaka78" wrote: Source Data I have the following data A B C D 1 1 2 2 2 3 3 3 6 4 0 0 5 0 0 Source Data is =Sheet1!$A$1:$b$5 When I am making the Chart I dont wont 0 to be part of the chart and I dont want to change the Source data range Can any one help with this |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data
What formula are you using, and which data gives you a point charted as zeo?
NA() will not be charted as zero, so you need to look at what your formula is generating. -- David Biddulph "osaka78" wrote in message ... yes it's as a result of formula , it does't work Zero is charted still "Mike H" wrote: Hi, How is the zero derived? If it's as a result of a formula make the formula return NA instead of zero and Excel won't chart it. Fir example IF(C2=1,C2,NA()) Mike "osaka78" wrote: Source Data I have the following data A B C D 1 1 2 2 2 3 3 3 6 4 0 0 5 0 0 Source Data is =Sheet1!$A$1:$b$5 When I am making the Chart I don't wont 0 to be part of the chart and I don't want to change the Source data range Can any one help with this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) |