hide pivot table

  • Thread starter Thread starter forest
  • Start date Start date
F

forest

All I want to show is the graph from the pivot table- I do not want the show
the filtered data.
 
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
 
Select the sheet with the PivotTable. Format - Sheet - hide.

Also, from the PivotTable tool bar, you can hide the PivotField buttons, if
desired.
 
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.
 
Back
Top