Need a way to create graph that contains specific parent/child rows
One of my users has a sheet with a "Task" column that contains multiple parent/child rows. I'm trying to help him find a way to create a chart based on a specific parent/child row, but I'm not entirely sure how to go about this. I was thinking of adding a helper column in, but I'm still lost on how I'd separate out the data for the chart....for example, we want to make a chart based on "HRSS Prep & Planning" that only includes data from the child rows. In this case, the data would be by status.
As always, I appreciate any and all guidance. Thank you so much for your time.