Forum Discussion
Solved
Stacked column chart creation - data reconfiguration
How do I rearrange this data in the most efficient way to create a stacked column chart from it? The dates will be along the x-axis. The phytoplankton concentration (cells/mL) will be on the y-axis...
AmyEH Perhaps like in the attached file? Not sure though what you mean by "transpose group names as column headers".
@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.