Tracking percentage on a chart overtime
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?
Best Answer
-
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.
Answers
-
@Paul Newcome yes, it would be when a new row is added with an additional %
-
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 thank you, that worked!
Help Article Resources
Categories
Check out the Formula Handbook template!
