ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I reverse a legend in a stacked bar chart? (https://www.excelbanter.com/charts-charting-excel/93781-how-do-i-reverse-legend-stacked-bar-chart.html)

Chartmaker

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?

Bernard Liengme

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?





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com