Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 46
Default Move bar chart to behind lines

I have a chart which holds a bar series and two line series. The bar
series is displayed behind the lines (ie, they are drawn across the
front of the bars) but I would prefer it if they were drawn behind the bars.

I have searched but have been unable to find a way to achieve this. Is
it possible?

--
F

  #2   Report Post  
Junior Member
 
Posts: 12
Default

Hello,

It depends on the version of excel you have.

For Excel 2007,

Click on your chart.

Click on the design Ribbon.

Click on Select Data button in the Data Group on the left.

Select the Line Series in the Legend Entries (Series) area on the left of the Select Data Source Dialog Box.

Click on the Up and Down Arrows to move your Line series into the right position. Clicking up arrow will move it in front of the other series and moving it down will move it to the back of the other series.

Let me know if this helps.

Thanks

Steve=True
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
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
inserted lines move how to place lines in proper cell? Deschi Excel Worksheet Functions 0 February 8th 09 01:15 PM
Can i move multiple lines between workbooks Martin Ellis New Users to Excel 11 September 18th 07 01:13 AM
how to move lines in conjunction with graphs Shoque Charts and Charting in Excel 4 July 25th 06 02:07 PM
Vertical Lines on the Lines on 2 Axes Chart [email protected] Charts and Charting in Excel 3 March 3rd 06 04:14 AM


All times are GMT +1. The time now is 08:26 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"