Creating a line graph

[NaomiSH]

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 to put in a line chart where the X-axis is in months and the y axis is in values.  How do I build my visual (line graph)?  When I try the points are like a scatterplot in one row or none at all.

[NaomiSH]

Wait!  I think I'm close.  I just need to figure out how to get the months in the correct order.  They are listed in order on the uploaded data.

[ryan_mayu]

@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]

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.

[ryan_mayu · Accepted solution]

@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

[NaomiSH]

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