View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Pivot Chart Legend

You can delete the chart title, or change it to something more descriptive.
You can't change the label in the legend, but since there's only one
series, you could change the chart options so the legend doesn't show.

MarkN wrote:
Hello,

When I create a pivot chart that is simply a single category field and a
single data items field (no series fields), I get the simple column chart
that I want. This chart has 'Total' as its title and 'Total' as the legend
label. How can I modify the legend label to something more descriptive?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html