View Single Post
  #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