How to bring data points to front on a scatter plot?

M

Mkille

Hi -

I have a scatter plot with many points on it, and then 3 points which I have
connected by a line. Basically this is my base case and I am trying to see
where it lies in relation to the rest of the data points, problem is that
they rest of the data points are covering it up. Is there a way to "Bring to
Front", when I click on it and go to the Format Tab under Chart Tools the
"Bring to Front" option is greyed out and not available.

Any workarounds?
 
J

Jon Peltier

You can bring the markers in front by making the series the last in the plot
order sequence. The connecting lines will be behind all of the points,
because Excel puts markers in a layer in front of everything, and lines in a
layer behind that.

- Jon
 

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

Top