| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Do not show a portion of the data series if the value is 0
Say I have data as follows
Apr-09 May-09 Jun-09 1.00 2.00 2.00 0.00 1.00 1.00 0.00 0.00 2.00 If the quantities I have listed are driven off of formulas, how could I not plot the zero values. Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Do not show a portion of the data series if the value is 0
Would have been nice to see the formula but I will make one up
You might have =A1/10 Change it to =IF(A1=0,NA(),A1/10) When you make the chart, the cells with NA() (which display as #N/A) will not get plotted best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "asmithbcat" wrote in message ... Say I have data as follows Apr-09 May-09 Jun-09 1.00 2.00 2.00 0.00 1.00 1.00 0.00 0.00 2.00 If the quantities I have listed are driven off of formulas, how could I not plot the zero values. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show series name on the chart - but not at every data point | Charts and Charting in Excel | |||
| adding a line to show average for a data series on a chart | Charts and Charting in Excel | |||
| how do i remove a portion of data from a column | Excel Discussion (Misc queries) | |||
| How do I show only the last portion of text in a multi line cell? | Excel Worksheet Functions | |||
| how do i extend the series of a portion of a formula? | Excel Worksheet Functions | |||
Linear Mode
