Am I able to Change the Order of Items in the Legend on a Chart?
We would like to keep things consistent across the board for our PM's and business owners when it comes to the RAID Log. I have labeled them "1., 2., 3., 4." and it works in certain instances, but it's all over the place once we pull that info into charts on a dashboard. It now looks extra confusing. I am very new (3ish months) to Smartsheet - am I missing an easy way to order these? Thank you in advance! :)
Best Answer
-
How exactly are you currently getting them on the dashboard?
With those specifically, you could use a report, group it by status, then use the summary feature to get the counts for each and use this report to populate your chart.
If you want them in some order other than alphabetical, you would use a separate sheet with formulas containing cross sheet references. This will allow you to establish whatever order you want.
Answers
-
How exactly are you currently getting them on the dashboard?
With those specifically, you could use a report, group it by status, then use the summary feature to get the counts for each and use this report to populate your chart.
If you want them in some order other than alphabetical, you would use a separate sheet with formulas containing cross sheet references. This will allow you to establish whatever order you want.
-
Thank you, Paul! I will try that and report back with any other questions. I appreciate it!
