Home

Creating an XY chart with many lines

Nooby
Occasional Visitor

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:

 JanFebMarAprMayJunJulAugSepOctNovDec
X126.426.624.120.316.613.713.114.416.719.42224.6
Y113.814.212.710.28.36.25.45.97.18.510.412
X2656970727983817772666764
Y2444447526067655952494553
 

 

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):

 Capture.JPG and not this:

Capture.JPG

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies