Skip Point

[Ping]

Who know how to skip a data point? For example, ponit #1
is 60 point #3 is 90, but I would like skip the point #2.
Now the chart consider the point #2 is zero, I just want
to skip this point, I don't want to show any value on
this point.

Thank you very much.


Ping

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Ping.
Please use the newsgroup for further discussion.]

If the cell containing point 2 is a constant (or empty), select the
chart, then set the options in Tool | Options... | Chart tab | Plot
empty cells as: and select either 'not plotted' or 'interpolated'.

If the cell contains a formula resulting in 0 or "", replace the 0 (or
"") with NA(). XL will interpolate over point 2.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions