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?

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