Make regular chart out of Pivot Table data

[Jaffey]

Whenever I try to make a graph by selecting a row or column of pivot table data, Excel creates a whole new tab with a pivot table chart on it. Can this default be turned off? I'd like to be able to reference the cells directly from a graph on the same page as the pivot table.

 

[SkipVought]

Hi,

That's the way a PivotChart is created.

However, in the PivotChart, right click and select Location and select Object in and select the SHEET you want the chart embedded in.

Skip,

_[red][/red]