Help with advanced charting thru VBA?

[theliuman]

Hey guys, I'd really appreciate some help with this challenging problem, as I've not been able to figure it out. I've attached a sample spreadsheet for you to check out while I try to describe what the end-chart should be.

Basically, in the spreadsheet, I've already created a stacked chart that shows, per quarter basis, how much each Team's cash ratio is worth. This chart is easy gives me and others an easy-to-gauge overview for each Team.

Now my challenge that I cannot figure out is this:

How can I have another stacked chart, basically a subset of the created chart, that does the following:
- Similar to the existing chart with stacked Teams on top of each other.
- Filtered to only account for the Valuable Players (Column F) for each Quarter.
- Listed by Name on the chart (is this even possible?) one on top of another in their associated Teams.
- Sorted from top-to-bottom for each Team section, the most Cash Ratio player on top, to the least Cash Ratio player.

This is exceptionally challenging and I cannot even begin to wrap my head around this. Any help would be greatly appreciated!

[Andy Pope]

All of the charts can be created by using pivot tables/charts, no need for VBA.

[theliuman]

All of the charts can be created by using pivot tables/charts, no need for VBA.

That's... brilliant. Maybe it's time for me to learn Pivot Tables instead of VBA

Now would it be possible to print out each Name on the stacked bar graph?