I am trying to achieve a very specific format for a Bar in Pie Chart in Excel 2010. I need the points that are aggregated in the Pie Chart and displayed individually in the Stack Bar to display in the Pie Chart as well. In other words, show the points individually (no aggregation) in the Pie Chart as well as the Stack Bar individually. I have attached a workbook with the format I am trying to achieve.
Please keep in mind the chart you see in my workbook is just visual and is not dynamic.
I consider myself fluent in Excel and VBA but have never had this much trouble trying to achieve a particular format for a chart.
Any help would be greatly appreciated.