View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] brett.kaplan@gmail.com is offline
external usenet poster
 
Posts: 48
Default Plotting in Charts

I want to use a line graph but I have intermittent points (one point
every 3 months). Having blanks in the missing months causes the points
to show up but no lines connecting them. To get around this, I am
taking averages for the between months and then the line shows.
However, is there a way to say only show the point (ie, the icon it is
using on the graph - triangle, diamond, etc.) every 3 points?