Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default z-order of various lines and bars in an Excel 2007 chart

What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?

I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.

I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.

So, is there a procedure for adjusting the z-order of drop lines in an
Excel 2007 chart?

Thanks kindly.

Cheers,
Joseph
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change order of drop lines relative to the plotted data inExcel 2007 chart icystorm Excel Discussion (Misc queries) 0 April 1st 10 03:48 PM
In Excel 2007 chart with multiple lines, mouse doesn't track lines sfuelling Charts and Charting in Excel 1 August 19th 09 09:41 PM
Customise error bars on individual bars in a bar chart 2007 Millie Charts and Charting in Excel 2 April 25th 09 04:16 AM
How to reverse the order of bars in Bar Clustered chart? [email protected] Excel Discussion (Misc queries) 1 March 12th 07 07:42 AM
How do I set up a chart in Excel with lines and stacked bars? Jan Charts and Charting in Excel 2 May 26th 06 08:39 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"