New Row Detail on a pivot sheet is not auto updating on the graph
We are new to Pivot App and we are experiencing an issue this morning. We have a column titled Blend, it is NOT a drop-down list and the blend data is dynamic. As we add new blends it is typed into the cell for this column. We created a pivot sheet that counts the record by blend. Yesterday we added a row to the raw data that was a new blend. The pivot sheet updated, reflecting the new blend and the count BUT the dashboard graph did not update to show the new blend. I expected the graph to update once the pivot sheet was updated. Are we doing something wrong? We had to adjust the graph data to capture the new blend manually.
Dawn
Best Answer
-
The big question to answer is what's your graph based on: a report that pulls from the Pivot output sheet, or the Pivot output sheet itself? Answering that is a big hint on what is most likely to be going on.
On Dashbaords, when you base a chart on a report, where that chart looks for the data automatically "grows" to accommodate new things. When you base a chart on a sheet though, you generally choose ONLY specific cells - so it doesn't look outside the original range when it was initially set up.
I suggest verifying if my theory is accurate by viewing the Data Source on the chart widget. If my theory is correct, you may wish to create an intermediary report and update the chart's data source - especially if the column in question isn't a dropdown, it's quite likely new items will be added. Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
The big question to answer is what's your graph based on: a report that pulls from the Pivot output sheet, or the Pivot output sheet itself? Answering that is a big hint on what is most likely to be going on.
On Dashbaords, when you base a chart on a report, where that chart looks for the data automatically "grows" to accommodate new things. When you base a chart on a sheet though, you generally choose ONLY specific cells - so it doesn't look outside the original range when it was initially set up.
I suggest verifying if my theory is accurate by viewing the Data Source on the chart widget. If my theory is correct, you may wish to create an intermediary report and update the chart's data source - especially if the column in question isn't a dropdown, it's quite likely new items will be added. Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
You were correct. When we built a report from the pivot sheet, graphs updated as expected. Thank you !
