How do I reverse a legend in a stacked bar chart?

G

Guest

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Table at Base of Chart 4
changing the name in the legend 2
Stacking data from within a series within a bar chart 1
Stacked bar Chart in Excel 2007 1
Excel 2007 - Column charting 3
Stacked bars with textlegends in each stacked bar 7
using a picture as a stacked bar in chart 1
Legend changes after closing file 1

Top