View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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