Create Stacked Bar Chart from multiple columns of a summary report

edited 06/13/24 in Formulas and Functions

Hi there,

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,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!