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

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Filtered view of Visio Chart 0
Doughnut Chart linked with the slicer in the pivot table 0
Found few bugs in my daily routine of work in excel for MAC 0
Power Pivot. Yikes. 0
Pivot Tables and Filter Criteria Display 0
Write back from pivot table 1

Top