| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
eliminate zero value cells from a chart in Excel
I am trying to chart a series of data that has some zero value cells. I
don't want the chart to pick up zero value but rather treat them as a blank cell. Any idea how to do that? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
eliminate zero value cells from a chart in Excel
1) Replace the zeros by =NA() which the chart engine ignores.
OR 2) Replace them with blanks; then with chart selected use Tools |Options , open the Chart tab and specify how missing data is to be treated- interpolated is your best bet. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Rbenaroya" wrote in message ... I am trying to chart a series of data that has some zero value cells. I don't want the chart to pick up zero value but rather treat them as a blank cell. Any idea how to do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
| Fan charts | Charts and Charting in Excel | |||
Linear Mode
