Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Chartmaker
 
Posts: n/a
Default How do I reverse a legend in a stacked bar chart?

When creating a stacked bar chart we use different colors from light to dark.
The legend appears as dark to light. How do I reverse this without changing
the chart?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default How do I reverse a legend in a stacked bar chart?

One the chart, right click one data series (the one you want on the top of
legend); open the Format Data Series dialog.
Open the Series Order tab; click MoveUp until it is at top.
Repeat and move each as needed.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Chartmaker" wrote in message
...
When creating a stacked bar chart we use different colors from light to
dark.
The legend appears as dark to light. How do I reverse this without
changing
the chart?



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
Stacked Bar Chart - used for a Tornado Chart [email protected] Charts and Charting in Excel 3 April 5th 06 12:15 PM
How can I combine a stacked bar chart with stacked colum chart? Sin Charts and Charting in Excel 8 December 20th 05 03:50 AM
Stacked Chart help needed [email protected] Charts and Charting in Excel 5 November 14th 05 08:38 PM
Chart Legend Entries BillCPA Excel Discussion (Misc queries) 1 July 27th 05 11:32 PM
How to make a stacked bar chart using time? Jon Peltier Charts and Charting in Excel 0 February 3rd 05 05:56 AM


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

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"