Charts using 3 sets of data

Hi Kathryn, thanks for the query. You need to lay out your data in Excel like this, simplified, example:


Headings
A1(blank), B1 = "M&M", C1 = "Utilities", etc
Then in successive rows
Column A: "MD", B2 = 2, C2 = 4
Column A: "VP", B2 = 1, C2 = 2
Column A: "MD", B2 = 1, C2 = 1

Select the data, and using the wizard create a stacked column chart. On the Data Range tab of step 2 of the chart wizard, change "Series In:" to Rows. That should result in the chart you need.

Let me know if you need anything else.

Anthony