Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2007

Tip: Looking for answers? Try searching our database.

Drawing Order of Data Series on Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eddie McGlone - 06 Sep 2007 15:48 GMT
Hi all.
We have an Excel 2003 line chart which shows current performance against
this year's target, last year's actuals and last year's target.

Actual is very close to target at this moment in time and goes under the
other lines so it can't be seen. I want to make it the "top" line being drawn
on the chart so that it will obscure tho other lines, not the other way
about. (Similar to "Bring to Front" or "Send to Back" on a page layout
program.

Changing the data series order doesn't seem to make any difference to the
actual drawing order - only to the order of the legend entries.

I hope I'm just being dense here...

Cheers

Ed
Eddie McGlone - 06 Sep 2007 16:08 GMT
Doh! I knew I'd look stupid as soon as I posted.

I was moving the data series I wanted to show over the others to the top of
the list - it needs to go to the bottom of the list.

Think of the list as being "First" to "Last" in the order of drawing on the
screen and it seems a bit more logical.

Cheers

Ed
> Hi all.
> We have an Excel 2003 line chart which shows current performance against
[quoted text clipped - 15 lines]
>
> Ed
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.