View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Boris Boris is offline
external usenet poster
 
Posts: 67
Default scatter chart with gaps in series (XL 2007)

Hi Ed,
Thank you for the tip. I will certainly try it, though, for reasons as
pointed out by Jon, a 3D line graph is probably not appropriate for me for my
current chart... Pity this is not just an option (such as there is for
dealing with empty cells)....
Thanks again for your very helpful suggestion. Best wishes, Boris.


"Ed Ferrero" wrote:

Hi Boris,

I do not have 2007 installed at the moment, so I cannot test this, but try
changing the chart type to 3D Line. Then set the elevation, perspective, and
rotation to zero (in properties). Should look like a line chart and leave
gaps for NA() values, if I remember correctly.

Ed Ferrero
www.edferrero.com