pivotchart - (1) sometimes I only want to chart one or two of the columns but that forces me to update my table which affects other results
it would be good if when you run a pivot chart based on a pivot table you can drop a column of data from the chart without affecting base table. I use the pivot chart to summarise a number of variables but I want the chart to only show one or two of the variables.
Also when displaying data I like to use more than one pivot table, however you then have to update filters separately. it would be good if filters can be linked on more than one table so that they only need to be updated once. (I use 2 pivot tables to make the data clearer for someone reviewing the data)
Kenneth Barber commented
Using 2 PivotTables (1 for use as a PivotTable and 1 as the source of the PivotChart) is actually your best bet. If you really want, add your table to the Power Pivot Data Model. Then both your PivotTable (the one for use as a PivotTable) and your PivotChart would be based on the version of the table in the Data Model. PivotCharts based on the Data Model don't need a corresponding PivotTable.