PC Review


Reply
Thread Tools Rate Thread

Plotted line to show OVER plotted points

 
 
andrefrancis
Guest
Posts: n/a
 
      24th Nov 2003

I have two separate plots on one chart. A set of points (blobs) and
separate fitted line. However the line is 'engulfed' by the points.
have tried 'series order' - but it doesn't stop the points appearing o
top of the line

How do I ensure the line properly displays on top of the points

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      24th Nov 2003
This works if both series are Scatter. Plot the points-only series on
the primary axis, and the line-only series on the secondary. The lines
connecting the second series will overlie the points of the first.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

andrefrancis wrote:

> I have two separate plots on one chart. A set of points (blobs) and a
> separate fitted line. However the line is 'engulfed' by the points. I
> have tried 'series order' - but it doesn't stop the points appearing on
> top of the line
>
> How do I ensure the line properly displays on top of the points?
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>


 
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
Chart does not render plotted points correctly, data comes from a Rogerph100 Microsoft Excel Charting 3 28th Oct 2008 02:58 PM
graph does not show all plotted points =?Utf-8?B?YWRlbGU=?= Microsoft Excel Charting 0 30th Aug 2005 03:05 PM
Pointing to plotted points to see the data Microsoft Excel Charting 1 10th Sep 2004 04:57 AM
Outlook 2002 crashes over and over and over and over and over and over typoo Microsoft Outlook Discussion 5 7th Mar 2004 08:12 PM
X axis points plotted at #.5 Joe Dudas Microsoft Excel Charting 1 5th Dec 2003 05:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:47 AM.