Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
rainbowraven
 
Posts: n/a
Default How do you invert legend data?

My boss wants the legend inverted, instead of the 8% at the top, he'd like
the 12% at the top and the 8% at the bottom. I switched the cells around
thinking that it would switch the legend data as well, no go. Anyone have an
idea?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do you invert legend data?

Hi,

The legend order is dependent on 3 things.
The series order
the chart type of a series
the axis upon which it is plotted

If they series are all on the same axis and of the same chart type then
have a look at the series order tab on the format dialog. Double click a
series to display this dialog.

Cheers
Andy

rainbowraven wrote:
My boss wants the legend inverted, instead of the 8% at the top, he'd like
the 12% at the top and the 8% at the bottom. I switched the cells around
thinking that it would switch the legend data as well, no go. Anyone have an
idea?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Hide series names for unused data from chart legend Neil Goldwasser Charts and Charting in Excel 4 February 10th 06 07:13 PM
Hiding data series in legend RED Charts and Charting in Excel 1 February 8th 06 04:00 PM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


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