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

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?

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

Yes, there is a workaround to bring the data points to the front on a scatter plot. Here are the steps:

1. Select the scatter plot chart by clicking on it.
2. Right-click on one of the data points that you want to bring to the front.
3. From the drop-down menu, select "Format Data Point."
4. In the "Format Data Point" pane that appears on the right-hand side of the screen, click on the "Marker Options" tab.
5. Under "Marker Options," select the marker type that you are using for your data points (e.g. circle, square, etc.).
6. Under "Marker Options," adjust the "Size" slider to make the data point larger.
7. Under "Marker Options," adjust the "Transparency" slider to make the data point more opaque.
8. Click "Close" to close the "Format Data Point" pane.
9. Repeat steps 2-8 for each data point that you want to bring to the front.

By making the data points larger and more opaque, they will appear to be in front of the other data points on the scatter plot. This workaround should allow you to see your base case data points more clearly in relation to the rest of the data.

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

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" wrote in message
...
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?