Charts Should Grow When New Pivot Values Added

MariaCurtis

Currently, if a new pivot value is added to a pivot table, the new value doesn't automatically pull in to a dashboard chart. You have to go and edit the dashboard chart to now pull in the new value.

It would be nice if you could point the dashboard chart to the pivot table as a whole, so that when that pivot table grows, the dashboard chart would adjust automatically to include the new value.

There is a workaround I've discovered, but it's manual and defeats the point of having the Pivot App.

Genevieve P.

Hi @MariaCurtis

Thanks for posting your idea!

As an alternate solution, I would personally use a Report as the source for the chart. If you set the Report filter to grab all the rows that are "not blank", then as new rows are added into the source sheet, they will automatically appear in the Report (and therefore your chart!)

Cheers,
Genevieve

MariaCurtis

Hi Genevieve,

Thanks for the suggestion. But when we have multiple charts we want to build off of the same report, it's much faster to build a pivot from the report than it is to regroup and re-save the report as a new report, for the sole purpose of another chart on the dashboard. I like that with pivot I can reference the same report in many pivots, without having to change the report around.