PC Review


Reply
Thread Tools Rate Thread

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

 
 
Mkille
Guest
Posts: n/a
 
      21st Aug 2008
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?
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      22nd Aug 2008
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" <(E-Mail Removed)> wrote in message
news:6754CDE5-8399-4711-8B98-(E-Mail Removed)...
> 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?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workable Scatter Plot Data Points Dave_AD Microsoft Excel Programming 5 3rd Jan 2008 04:08 AM
Scatter plot - Size of data points from spreadsheet value? ferdy Microsoft Excel Charting 2 2nd Oct 2006 02:32 PM
How do I make my data points not overlap in a scatter plot? =?Utf-8?B?c2ZkYw==?= Microsoft Excel Charting 2 30th Jan 2006 03:31 AM
How do I have unique data labels for points in a XY Scatter plot? =?Utf-8?B?aGV5aG93eml0Z29pbg==?= Microsoft Excel Charting 1 18th Jan 2006 03:33 PM
how to add data points to a scatter plot with trend line =?Utf-8?B?U2FtYW50aGE=?= Microsoft Excel Charting 2 28th Feb 2005 12:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:18 PM.