Pivot Table Chart Options

[Guest]

Is there a way to hide the field buttons in a Pivot Chart?
Also, is there a way to resize the chart (bigger or smaller)?

Thanks,
Fred

 

[Debra Dalgleish]

To hide the field buttons, select the pivot chart.
On the PivotTable toolbar, choose PivotChart>Hide PivotChart Field Buttons

You can't change the size of the plot area in a pivot chart. If you
create a normal chart from the pivot table, you can adjust the size.
There are instructions on Jon Peltier's web site:

http://peltiertech.com/Excel/Pivots/pivotcharts.htm

 

[Guest]

Ms. Dalgleish,

Thanks a million for your help...your tips worked for me...

Fred