Producing a plotted graph in Excel 2016 for given data

[gsrlb]

Hi, I am a novice and am struggling with the below. Any help on this is highly appreciated please.

[FONT=&quot]Produce a simple graph – 1 graph with 3 plotted lines on it – whereby the axes accommodate full and accurate spatial dimensions. Not just accommodating the supplied raw data points evenly across the axis .[/FONT]
[FONT=&quot] [/FONT]
[TABLE="width: 1"]
<tbody>[TR]
[TD] [FONT=&quot]# of lines/#of PO's[/FONT]
[/TD]
[TD] [FONT=&quot]5 PO's[/FONT]
[/TD]
[TD] [FONT=&quot]10 PO's[/FONT]
[/TD]
[TD] [FONT=&quot]20 PO's[/FONT]
[/TD]
[TD] [FONT=&quot]50 PO's[/FONT]
[/TD]
[/TR]
[TR]
[TD] [FONT=&quot]4 lines[/FONT]
[/TD]
[TD] [FONT=&quot]8 min[/FONT]
[/TD]
[TD] [FONT=&quot]16 min[/FONT]
[/TD]
[TD] [FONT=&quot]32 min[/FONT]
[/TD]
[TD] [FONT=&quot]80 min[/FONT]
[/TD]
[/TR]
[TR]
[TD] [FONT=&quot]8 lines[/FONT]
[/TD]
[TD] [FONT=&quot]10 min[/FONT]
[/TD]
[TD] [FONT=&quot]18 min[/FONT]
[/TD]
[TD] [FONT=&quot]35 min[/FONT]
[/TD]
[TD] [FONT=&quot]92 min[/FONT]
[/TD]
[/TR]
[TR]
[TD] [FONT=&quot]12 lines[/FONT]
[/TD]
[TD] [FONT=&quot] 14 min[/FONT]
[/TD]
[TD] [FONT=&quot]24 mins[/FONT]
[/TD]
[TD] [FONT=&quot]40 min[/FONT]
[/TD]
[TD] [FONT=&quot]104 min[/FONT]
[/TD]
[/TR]
</tbody>[/TABLE]

[FONT=&quot]
[/FONT]
[FONT=&quot] Axes = PO’s AND minutes. Plotted lines = each of the 3 line numbers scenarios. Is this doable?
[/FONT]

 

[Oscar Cronquist]

Is this what you are looking for?

 

[Oscar Cronquist]

or this:

 

[gsrlb]

Thank you so much Oscar. What is the difference between the 2? Can I also request for the excel workbook with both the graphs please?

 

[Oscar Cronquist]

The first chart is a line chart. You can see the source data I am using and the series in the following picture.

The second chart is a xy scatter chart with straight lines.

You don't need a workbook, the images above show you how they are built.

 

[gsrlb]

The first chart is a line chart. You can see the source data I am using and the series in the following picture.

The second chart is a xy scatter chart with straight lines.

You don't need a workbook, the images above show you how they are built.

_______________________________

Thank you again Oscar.
_

 

[gsrlb]

Thank you again Oscar. Could you as well advise on how to Convert the table into a modeller/ready reckoner that provides for modelling additional PO columns AND additional #lines rows

 

[Oscar Cronquist]

Thank you again Oscar. Could you as well advise on how to Convert the table into a modeller/ready reckoner that provides for modelling additional PO columns AND additional #lines rows

I believe you have to manually add additional series to your chart.