Hi there,
I'm trying to create a chart that has many lines, in which each line is defined by its x and y coordinates. For example, for January, the maximum X,Y coordinate may be (25,33.3) and its minimum may be (13, 44.7). It's the x-value that determines where whether it's a maximum or minimum.
The axes of the chart is supposed to be X and Y and each set of lines will have its own label, perhaps Jan, Feb, Mar and so on. The table looks a bit like this:
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| X1 | 26.4 | 26.6 | 24.1 | 20.3 | 16.6 | 13.7 | 13.1 | 14.4 | 16.7 | 19.4 | 22 | 24.6 |
| Y1 | 13.8 | 14.2 | 12.7 | 10.2 | 8.3 | 6.2 | 5.4 | 5.9 | 7.1 | 8.5 | 10.4 | 12 |
| X2 | 65 | 69 | 70 | 72 | 79 | 83 | 81 | 77 | 72 | 66 | 67 | 64 |
| Y2 | 44 | 44 | 47 | 52 | 60 | 67 | 65 | 59 | 52 | 49 | 45 | 53 |
How can I create a chart where Jan is just 1 straight line with the corresponding X,Y values and not 4 points with different Y-values? Like this (ignore the background image. I just need to plot the many lines you see here):
