Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
Hiding data series in legend | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |