Pivot Chart Legend
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? -- Thanks, MarkN |
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 |
All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com