Hi. I'm new to this level of sophistication in Excel so please forgive me if this has been asked and answered a hundred times before. I did search for this but couldn't find an appropriate question or response.
I have a table that has duplicate identifiers in the rows but different values in the columns. I need to create a stacked column chart with the columns as the categories but aggregates of the rows as the series. Is this possible?
So if this is my data:
snap00500.jpg
This is what I want (I had to hack the data to get this):
snap00499.jpg
One other thing... As shown in the chart, if I'm only charting the first three columns, I don't want any values in the fourth column to be included and any rows that have no values in the first three columns should not even appear in the legend (A4 in the above example).
Is there a way of achieving this without using PivotTables/PivotCharts or Power Query?
Thanks!
Bookmarks