Forum Discussion
Table manipulation
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.
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 feel like your first sentence is my answer but I need to google terms now, thank you for that! Just to confirm, this will allow me to do a line chart, for example, for each month sequentially from 1940-1945 if I want to?Subodh_Tiwari_sktneer
To plot the line chart for multiple years, you may have the setup shown in the attached.
If you move the chart, you will find the chart data preparation underneath it.
You may select the CheckBoxes for years to show the line for that year in the chart.