Create Stacked Bar Chart from multiple columns of a summary report
I've been runing around in circles for a while now and was hoping you could help.
Here is my issue:
I am using smartsheet to do some UATs on a project. I have several test sheets and would like to do some reporting on testing advancement by using stacked bar charts.
Agregating all my test sheets into a summary report I want to have the amount of test cases / Status / Tool.
How one of my data sheets looks like:
My report summary:
Now I want to build a nice stacked bar chart on my dashboard:
What I have:
But I want something like:
What am I doing wrong here?
Thanks for your help,
Help Article Resources
Check out the Formula Handbook template!