Pivot Table Chart Options
 

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

Pivot Table Chart Options
 

To hide the field buttons, select the pivot chart.
On the PivotTable toolbar, choose PivotChartHide 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

Fred wrote:
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)?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Chart Options
 

Ms. Dalgleish,

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

Fred

"Debra Dalgleish" wrote:

To hide the field buttons, select the pivot chart.
On the PivotTable toolbar, choose PivotChartHide 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

Fred wrote:
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)?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html