Resize plot area in a pivot chart
I'm trying to change the size of the plot area of a pivot pie chart within
the chart area. I have no problem doing this with a regular chart but I can't seem to do it with a pivot chart. Also, I want to change the size of the data drop down in the pivot chart, can the size of this be changed? |
Resize plot area in a pivot chart
Unfortunately, you can't change either of those items in a pivot chart
in Excel 2003 or earlier version. Jon Peltier has instructions for creating a normal chart from pivot table data: http://peltiertech.com/Excel/Pivots/pivotcharts.htm Aaron wrote: I'm trying to change the size of the plot area of a pivot pie chart within the chart area. I have no problem doing this with a regular chart but I can't seem to do it with a pivot chart. Also, I want to change the size of the data drop down in the pivot chart, can the size of this be changed? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com