Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart Legend
Hello all.
I am currently developng a Line chart via a pivot table. One thing I have noticed is that the legend runs in ascending order. E.g. Z at the top down to A's at the bottom. Is there any way of getting the legend "flipped" so it runs A-Z without amending the pivot table itself?? Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart Legend
Hi,
Double check the chart type. A flipped legend would suggest a Stacked Line chart rather than a plain Line chart. Cheers Andy Chiccada wrote: Hello all. I am currently developng a Line chart via a pivot table. One thing I have noticed is that the legend runs in ascending order. E.g. Z at the top down to A's at the bottom. Is there any way of getting the legend "flipped" so it runs A-Z without amending the pivot table itself?? Thank you. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart Legend
I believe this is controlled by the order of the series in the pivot table,
which is usually in Ascending order. Although you said you don't want to amend the pivot table maybe it would be alright to sort the field in Ascending order in the PT? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chiccada" wrote: Hello all. I am currently developng a Line chart via a pivot table. One thing I have noticed is that the legend runs in ascending order. E.g. Z at the top down to A's at the bottom. Is there any way of getting the legend "flipped" so it runs A-Z without amending the pivot table itself?? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change the text in the legend of a chart w/o changing pivot text | Charts and Charting in Excel | |||
How do I show a data table with legend keys in a line chart? | Charts and Charting in Excel | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Change a legend in Pivot Chart Report | Excel Discussion (Misc queries) | |||
Pivot Chart Legend | Excel Discussion (Misc queries) |