Markers making things too busy

G

Guest

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

offset data markers 1
Excel Data Markers, Limit Qty 4
Flawed scatter plot function 2
How to adjust the weight of markers 2
How do I put markers on a scatter graph only for my labeled points 2
How to change the spacing of data markers in a line/scatter chart 1
Shaded 'radar' graph with markers 2
How do I change the order of the line versus the marker for a scat 4

Top