Chart

[tjb1982]

***Attachment removed***

Hello

Please see example data above. I have been tasked with creating a complex chart for one of my boss's bosses. The data doesn't seem to want to work with me, though. I've tried to do research on PivotTables/Charts, but it seems that the report she wants is too complex for the simple examples I'm finding online. I admit I'm not really experienced with creating reports in Excel, so any help would be greatly appreciated.

I want to make a chart where the y-axis equals Market Value, the x-axis is a list of regions, and each region has two bars that each represent two different types of Market Value (named vs. not-named). I would then like to divide these bars by color into ratios indicating the tally of small accounts vs. larger accounts. Is this possible? Does anyone know where I could find a tutorial on how to do something like that?


Thank you!