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.

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

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.