Chart

***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!

I see that you removed your sample file, is there any way you could post some data? Also maybe create a mockup of what you need the chart to look like?

Hi TJB, welcome to the forum.

Along with possibly re-posting sample data, please take a moment to read the forum rules (link in my signature) and then amend your thread title to something descriptive of your problem. Rule #1 deals with proper thread titles.

Thank you.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST