Combining Clustered and Stacked on one data set.

[smcneil1]

Hello forum members,

I need help creating a bar graph with two seperate data sets. On the first data set, I would like to compare in one bar, "Budgeted", with another bar, "Raised." Here's the kicker, on those two graphs, I want to segment the funds based on location.


Budgeted Raised
North Texas 3,870,000 1,302,000
Dallas 3,620,000 1,300,000
Tarrant 250,000 2,000
Campaign 5,000,000 1,000,000

As you will see, North Texas is the overall sum of both Dallas and Tarrant. So, on both the budgeted and raised bars, I would like the region stacked. Please let me know if this makes sense. The campaign section should stand alone and not be seperated by location.

I have attached the data and an imagine. Thanks!

Excel Forum Example.xlsxphoto.JPGExcel Forum Example.xlsxphoto.JPG

[Andy Pope]

Change your data layout.