Good morning, I've done several searches here but now I'm going in circles.
I have a sheet with records of usage of certain scripts we have. Each row has the user name, the script they used and the time they saved by using each script.
My goal is to create a dashboard with two bar charts:
- user name vs total time savings (ordered by highest time savings)
- most used scripts (ordered highest count)
The charts are ready but the bars can't be reordered which makes them pointless. Also, the reports they've been created from can't be ordered based on the sums, which means this approach didn't work. I then tried using a blank sheet with formulas showing the total savings per user and create the chart on top of that but now my chart won't update when a new user shows up in the sheet.
Can anyone see a way I can achieve that? Thank you :-)