graphing data as is

[daveyc18]

historical-rate-sheet---Janaury-2021.xlsx

Table 1 FIXED RATES OF THE PAST 25 YEARS AVERAGE RESIDENTIAL MORTGAGE LENDING RATE – 5 YEAR Year,January,February,March,April,May,June,July,August,September,October,November,December,Average 1996,8.02%,7.79%,8.16%,8.48%,8.47%,8.48%,8.48%,8.07%,7.94%,7.50%,7.01%,6.94%,7.95% 1997,7.14%,7.12%,7.06%...

docs.google.com

I'd like the percentages on the y axis and the dates on the x axis (by month -year)

I'd like both variable and fixed rates to be on the same graph and have both historical averages on there

doable without having to change/transpose the data ?

 

[daveyc18]

historical-rate-sheet---Janaury-2021.xlsx

Table 1 FIXED RATES OF THE PAST 25 YEARS AVERAGE RESIDENTIAL MORTGAGE LENDING RATE – 5 YEAR Year,January,February,March,April,May,June,July,August,September,October,November,December,Average 1996,8.02%,7.79%,8.16%,8.48%,8.47%,8.48%,8.48%,8.07%,7.94%,7.50%,7.01%,6.94%,7.95% 1997,7.14%,7.12%,7.06%...

docs.google.com

I'd like the percentages on the y axis and the dates on the x axis (by month -year)

I'd like both variable and fixed rates to be on the same graph and have both historical averages on there

doable without having to change/transpose the data ?

anybody???