| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Not plot zero on line chart without using NA?
Is there any way to have a line chart ignore the zeros other than manipulate
the formula to show NA? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Not plot zero on line chart without using NA?
If there were, would we settle for using NA()? We've been asking for
something better for several versions of Excel. There are two options: use NA() in the formula, or delete the formula altogether. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Homer wrote: Is there any way to have a line chart ignore the zeros other than manipulate the formula to show NA? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Not plot zero on line chart without using NA?
That's what I thought, but I figured I'd take a shot at someone having a
slick work around. I guess NA is the slick work around. Sounds like Microsoft is as reseptive to changing the headaches as Autodesk is. Thanks for the help. "Jon Peltier" wrote: If there were, would we settle for using NA()? We've been asking for something better for several versions of Excel. There are two options: use NA() in the formula, or delete the formula altogether. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Homer wrote: Is there any way to have a line chart ignore the zeros other than manipulate the formula to show NA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
| Getting a line chart to NOT plot a zero value | Charts and Charting in Excel | |||
| How do I plot a line chart in 3 dimensions (x,y,z)? | Charts and Charting in Excel | |||
| Excel chart : I want to plot on the same chart bar and line | Charts and Charting in Excel | |||
| I want to draw a line through the columns of a chart, plot the o. | Charts and Charting in Excel | |||
Linear Mode
