ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table/Chart Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/104060-pivot-table-chart-formatting.html)

Chard

Pivot Table/Chart Formatting
 

Hello

How do I remove the Field Name Boxes that appear on pivot table reports
and charts?

Also how do I remove the 'Drop Page Fields Here' title on the Pivot
Chart?

Many thanks!

Chard


--
Chard
------------------------------------------------------------------------
Chard's Profile: http://www.excelforum.com/member.php...o&userid=37200
View this thread: http://www.excelforum.com/showthread...hreadid=570042


Debra Dalgleish

Pivot Table/Chart Formatting
 
With the pivot chart selected, on the pivot toolbar, choose
PivotChartHide PivotChart Field buttons.

Chard wrote:
Hello

How do I remove the Field Name Boxes that appear on pivot table reports
and charts?

Also how do I remove the 'Drop Page Fields Here' title on the Pivot
Chart?

Many thanks!

Chard




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



All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com