Stacked Bar Graph - Reflect 3 columns

Hi @Chris Holt

There are a few different ways that you can display the data, depending on what you'd prefer. Personally, I would break it out per-person, and create one Chart Widget for each of the sections you have above, broken down by Quarter and Method, like so:

Notice that at the bottom I have some Pie charts per-quarter showing the percent of the different Method Types. I did this by creating a Totals section of data at the bottom of the metric sheet.

You can then customize the colours in each chart to match up, so Blue always represents "Email - Personal" across all your widgets, etc. Would this work for you?

As an alternative, you could create a Helper Column to add together the text from your Name column and Method Type.

This would create a unique text identifier for the Chart Widget's x-axis. You can Sort the Sheet by Method Type so they are grouped together, then do a chart like so:

Or you could do the opposite to what I showed in the first example above, where you have one chart widget per-method type: the title of the chart would be the method type and the x-axis would show the Name, the bars showing each person's data. Let me know if you want to see an example of what I mean and I'm happy to create another demo.

Cheers!

Genevieve