Forum Discussion
Stacked column chart creation - data reconfiguration
AmyEH Perhaps like in the attached file? Not sure though what you mean by "transpose group names as column headers".
Riny_van_Eekelen Yes, this is exactly what I mean. How do I do this? I am using Excel 2016.
I had made a Pivot Table, so it looks like I was on the right track there, as that's what you did. When I made my table, all the dates were grouped by month. For each row (each month) the table had summed the number of values and showed that sum for each column (each group name). How do I tell the table to display each unique date instead of grouping them by month? If each unique date is displayed, then each value will be displayed too, instead of a sum. That is the end result needs to look like. Essentially, how do I make my Pivot Table look like yours so I can create that stacked column chart from it?
@Riny_van_Eeklen
I figured it out. I discovered how to change the action from counts to a sum of the values. I also figured out how to ungroup the dates so they show as unique dates instead of grouped by month. Thanks for showing me it was possible, motivating me to keep working on solutions to these two problems.
Appreciate the help!
AmyEH Had been away from my computer all day, so couldn't respond earlier. Glad you figured it out.