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

"forest" wrote in message
...
All I want to show is the graph from the pivot table- I do not want the
show
the filtered data.

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

Also, from the PivotTable tool bar, you can hide the PivotField buttons, if
desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"forest" wrote:

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

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.

"forest" wrote:

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