Forum Discussion
Solved
Table manipulation
I have this table and I would like to graph the trends over the years. I don't know how to get excel to see 1940 Jan-dec and then cycle to 1941. I could pivot it all to two columns (date mm/yyyy and ...
Your data is already in the pivoted form so ideally you should unpivot it using the Power Query and insert a Pivot Chart with Months in Rows along with a Slicer on Year.
The attached shows another approach where you can derive the chart data based on a year selected from the dropdown on sheet2.
See if this is something you can work with.
I would also like to know something similar. Thank you for asking.