Forum Discussion

NaomiSH's avatar
NaomiSH
Regular Visitor
1 year ago
Solved

Creating a line graph

Good afternoon, Thanks for your help on my last question.  I now have another that has probably already been asked and answered but I can't seem to find it.  I have a single row of data I am trying ...
Need Help
Show and Tell
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    NaomiSH 

    in pq you can create a new column

     

    = if [2025] = "January" then 1
    else if [2025] = "February" then 2
    else if [2025] = "March" then 3
    else if [2025] = "April" then 4
    else if [2025] = "May" then 5
    else if [2025] = "June" then 6
    else if [2025] = "July" then 7
    else if [2025] = "August" then 8
    else if [2025] = "September" then 9
    else if [2025] = "October" then 10
    else if [2025] = "November" then 11
    else if [2025] = "December" then 12
    else null

     

     

    then make sure the new column's data type is whole number and sort 2025 by the new column

     

     

    at last sort by the 2025 column

     

    pls see the attachment below

ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

NaomiSH 

I think you need to go to Power query 

 

1. use header as first row

 

2. transpose

 

then you drag column 1 to x-aixs and column 2 to y x-axis to build the line chart.

 

 

 

  • NaomiSH's avatar
    NaomiSH
    Regular Visitor
    1 year ago

    I ran it through PowerQuery.  Obviously, I can post real data on here but after running through PowerQuery, this is (kind of) what is loaded.

    • NaomiSH's avatar
      NaomiSH
      Regular Visitor
      1 year ago

      I tried doing it with the two columns (one column months, one column data) but it is setting it to count.

       

       

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      1 year ago

      NaomiSH 

      in pq you can create a new column

       

      = if [2025] = "January" then 1
      else if [2025] = "February" then 2
      else if [2025] = "March" then 3
      else if [2025] = "April" then 4
      else if [2025] = "May" then 5
      else if [2025] = "June" then 6
      else if [2025] = "July" then 7
      else if [2025] = "August" then 8
      else if [2025] = "September" then 9
      else if [2025] = "October" then 10
      else if [2025] = "November" then 11
      else if [2025] = "December" then 12
      else null

       

       

      then make sure the new column's data type is whole number and sort 2025 by the new column

       

       

      at last sort by the 2025 column

       

      pls see the attachment below