Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table grand total options | Excel Discussion (Misc queries) | |||
Please let me know more options about Pivot Table | Excel Worksheet Functions | |||
Pivot Table - Options | Excel Worksheet Functions | |||
Pivot Table - Default Settings for Table Options | Excel Discussion (Misc queries) | |||
Pivot Table Refresh Options | Excel Discussion (Misc queries) |