Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

3,359 views
Skip to first unread message

Mkille

unread,
Aug 21, 2008, 4:58:07 PM8/21/08
to
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?

Jon Peltier

unread,
Aug 21, 2008, 9:37:11 PM8/21/08
to
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mkille" <Mki...@discussions.microsoft.com> wrote in message
news:6754CDE5-8399-4711...@microsoft.com...

0 new messages