Tracking percentage on a chart overtime

Alicia D

Hello! I am trying to figure out how to create a line chart that shows the updated % every time it is recorded. I know how to change the percentage complete by using formulas, but this percent is an actual percentage of a recorded number. Not a progression percentage. Is there a way for me to do this so I don't have to update the chart every time a new percentage is recorded?

Paul Newcome

Try creating a row report from the sheet and filter it to only show rows where the percentage is not blank, then create your chart from this report.

Paul Newcome

DO you mean a new row is added?

Alicia D

@Paul Newcome yes, it would be when a new row is added with an additional %

Paul Newcome

Try creating a row report from the sheet and filter it to only show rows where the percentage is not blank, then create your chart from this report.

Alicia D

@Paul Newcome thank you, that worked!

Paul Newcome

Happy to help. 👍️