Hi,
The simplest way to do this is to plot 2 series. The first series plots all
points and is just the connecting line with no data markers.
The 2nd series is used to just display markers. and is based on a subset of
the original data.
Assuming you x and y data is in column A and B you could use this formula in
C to display every 5th marker
=IF(MOD(ROW()-1,5)=0,B1,NA())
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Libby" wrote in message
...
I have a scatter chart with data points connected by lines. I would like
to
put in point markers, but the data is too busy. Is there any way to have
Excel put in markers for only 1 out of every 5 charted points?
Libby