Help Creating a Chart With Three Data Criteria

Hello All,

I am stuck! I am trying to create a chart which will show data for the each region by 'Type' but all on a single chart. For example, I'd like to show the number of 3rd party Host Connection Failures, Invalid Input Files, etc...for each region for comparison purposes. For this specific chart, I am looking for a stacked bar chart (stacked by region) with 'Type' vertical and 'Count' horizontally using the data under 'All Incident Count Summary'. The model is the lower right corner in the attached picture.

Additionally, I'd like to create a vertical columns chart to display priority count by region. I'd like to show horizontally each of the four priorities (P1-P4) and the count for each of the four regions next to one another. The model is the lower left corner in the attached picture.

I have attached a picture of the charts I am trying to recreate along with my source data. The picture is showing data for the last 120 days, my source data is specific to one month.

Ant help is much appreciated!!

Thanks so much,
John

Yes Ben, these are four charts on one slide.

What I am asking for help with is recreating the bottom two charts. I cannot figure out how to populate the charts with three data points (region, count and type) or (region, count and priority).

Ben

Thanks so much for your help! That is exactly what I was looking for.

It's such a simple solution in creating the tables. Much appreciated!