Results 1 to 4 of 4

Thread: Unemployment chart

  1. #1
    Seeker xcel's Avatar
    Join Date
    May 2018
    Posts
    8
    Articles
    0
    Excel Version
    2016

    Unemployment chart



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    164
    Articles
    0
    Excel Version
    2016
    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!
    Attached Files Attached Files

  3. #3
    Seeker xcel's Avatar
    Join Date
    May 2018
    Posts
    8
    Articles
    0
    Excel Version
    2016
    Thank you Ed.That works great.Just out of curiosity, is it possible to achieve same results without the help of power query?

  4. #4
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    164
    Articles
    0
    Excel Version
    2016
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •