i am trying to create a line chart, but my dataset does not contain a singular date field. Instead, it contains multiple fields of the dates, and I'm having a hard time figuring out how to build it into a line chart. the line chart should go by months and should sum up the total for each of the months.
Do i need to use a Master Calendar? and if so what field would i put as Date?
this is my data table
Elements
January
February
March
April
May
June
July
August
September
October
Iron
4
5
6
6
7
7.7
8.4
9.1
9.8
10.5
Metal
7
1
0
4
8
11
15
18
22
25
Fiber
4
7
5
6
7
7
8
8
9
9
Sulphur
3
5
2
2
2
1
1
0
0
1
i have attached a sample file
Please suggest a workaround or a possible solution!
