Stacked Bar Chart Data Sheet

KatieDi

Hello

I am trying to create a stacked bar chart based on the following:

I have a multi-select dropdown column, so there may be more than one value in it.

I then have a second column with Priority listed.

I have created a sheet that calculates how many times each drop down is used but I want to know how each drop down relates to the priorities.

I'm looking for a chart to show me that, for example, 'user experience' makes up 5 x high priority items and 6 medium items etc.

There are more in the Risk or Issue Type than Priority which is why I want to incorporate the two on the same chart.

Can someone please help me with the formula?

Thanks in advance

Leibel S

@KatieDi

Using COUNTIFS you can keep on adding ranges and criteria.

=COUNTIFS({Risk or Issue Type Column}, HAS(@cell, [Risk or Issue Type]@row), {Priority Column}, @cell = "Critical")

Replace bolded parts of formula as needed...

KatieDi

This is great, thank you.

If I wanted to add in another criteria whereby it looks at another column and only counts if a certain criteria is met, e.g. Column name is 'Form Type', and I'm looking to bring in where the form type = contact form.

I'm sorry, I'm just not very competent at formulas.

Thank you

Katie

Leibel S

@KatieDi

Yes, you can keep on adding as much as you need:

=COUNTIFS({Risk or Issue Type Column}, HAS(@cell, [Risk or Issue Type]@row), {Priority Column}, @cell = "Critical", {Form Type}, @cell="contact form")