Unemployment chart

xcel

New member
Joined
May 13, 2018
Messages
8
Reaction score
0
Points
0
Excel Version(s)
2016
I was looking at the Bureau of labor statistics unemployment chart. They have created a line chart for every month since 1980 till date in one single line. When i tried to recreate this i am getting 12 line(one for each month). I could not figure out how i can get this one in one line. Can anyone help me to figure this one out.
 

Attachments

  • Unemployment line chart.xlsx
    19.4 KB · Views: 12
Here you go https://www.screencast.com/t/5usdheUe

Unpivoted your data in PQ/2, inserted a pivot table/3 and attached a graph with a slicer to allow you interrogate on a more micro basis/4 (use control to select multiple years within slicer).

Knock 'em dead Tiger!
 

Attachments

  • Unemployment line chart.xlsx
    68.2 KB · Views: 14
Thank you Ed.That works great.Just out of curiosity, is it possible to achieve same results without the help of power query?
 
Do not think you could as the months have already been pivoted and you need it un-pivoted, unless of course you like a lot of cut and paste
 
Back
Top