| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up a chart to only chart values greater than 0
I have a chart in Excell that I would like to only have chart those items
with a value of greater than 0 (zero). Not sure if there is a better, easier way than having manually manipulate the data. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set up a chart to only chart values greater than 0
Let's say the values are in B1:B20
In C1 enter =IF(B10,B1,NA()) Now use column C for the chart; the displayed #N/A values will be ignored by the chart engine best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "debra49424" wrote in message ... I have a chart in Excell that I would like to only have chart those items with a value of greater than 0 (zero). Not sure if there is a better, easier way than having manually manipulate the data. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set up a chart to only chart values greater than 0
This topic wasn't the reason I was looking through this discussion board but
I can definitely use the information! Thank you. "Bernard Liengme" wrote: Let's say the values are in B1:B20 In C1 enter =IF(B10,B1,NA()) Now use column C for the chart; the displayed #N/A values will be ignored by the chart engine best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "debra49424" wrote in message ... I have a chart in Excell that I would like to only have chart those items with a value of greater than 0 (zero). Not sure if there is a better, easier way than having manually manipulate the data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only chart numerical values, not error values | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
| Can I obtain x values from y values on an Excel chart? | Charts and Charting in Excel | |||
| Chart -- How to chart 65536 values in 1 series? | About this forum | |||
Linear Mode
