Resize plot area in a pivot chart

[Guest]

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]

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