Graphs - updating automatically
Best Answers
-
Hi Beth,
Would you mind clarifying what you mean? If the numbers used in a graph are updated on the source sheet, the graph automatically updates with these numbers.
If you are wanting to add new rows to graphs automatically, you could have the source for the graph be a Report that pulls in new rows based on specific content. When using a report for the source of the graph, it selects the entire data (versus just a section, like when you select a portion of a sheet). Would that work for you?
There's more information on charts in our Help Center (here).
Cheers,
Genevieve
-
That helps alot.. thank you!! I didn't realize the report would update the graph in that sense.
Answers
-
Hi Beth,
Would you mind clarifying what you mean? If the numbers used in a graph are updated on the source sheet, the graph automatically updates with these numbers.
If you are wanting to add new rows to graphs automatically, you could have the source for the graph be a Report that pulls in new rows based on specific content. When using a report for the source of the graph, it selects the entire data (versus just a section, like when you select a portion of a sheet). Would that work for you?
There's more information on charts in our Help Center (here).
Cheers,
Genevieve
-
That helps alot.. thank you!! I didn't realize the report would update the graph in that sense.
-
Great! Glad that will work for you. Let me know if you have any questions when building this out.