Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter Plot
How do I avoid the scatter plot from charting blank observations as zeros?
Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter Plot
If the cells are truly blank (no formulas, no stray characters), go to Tools
menu Options, and on the Chart tab, select the Not Plotted option for 'Plot Empty Cells As...'. If the cells contain a formula that returns "" for one condition, Excel treats the "" as a text value, which is converted to a zero for plotting. Change "" to NA(), which puts an ugly error in the cell; the chart has a line interpolated across the missing point. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Liz23" wrote in message ... How do I avoid the scatter plot from charting blank observations as zeros? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Point labels in an Excel scatter plot to be associated text | Charts and Charting in Excel | |||
Zooming in on a Scatter Plot | Charts and Charting in Excel | |||
Add names to scatter plot chart | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel |