hide pivot table

F

forest

All I want to show is the graph from the pivot table- I do not want the show
the filtered data.
 
B

Bob Phillips

Then I have to ask, why bother with a pivot table if you aren't going to let
the users pivot the data, why not just build a graph?

HTH

Bob
 
L

Luke M

Select the sheet with the PivotTable. Format - Sheet - hide.

Also, from the PivotTable tool bar, you can hide the PivotField buttons, if
desired.
 
T

trip_to_tokyo

Right click in the Chart Area of the Pivot Chart / select Move Chart / click
on New sheet: / OK.

Now all you will have will be the graph as you require.

Please hit Yes if my comments have helped.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
pivot table data 2
Pivot Table Count Issue 6
Selecting Fields in Pivot Table 2
Pivot Table- Show Data % of 1
How do I hide hide #REF! in Excel 3
Pivot report and Filter boxes 1
Pivot Table - Changes 5

Top