Make regular chart out of Pivot Table data
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.
|