Plotting two separate curves in a graph.

[haseeb99b]

Hi. I have following data. By the variation first two parameters we get different final value. I want a graph such that length is on x axis and piston displacement is on y axis. Both rpm have different curves.... Regards



Length-------Rotation (N)-----------Piston Displacement (x)
(m)--------------(rpm)
0.085---------------400---------------0.054016713
0.16----------------400---------------0.051776629
10------------------400---------------0.049382605
0.085--------------8000---------------0.042101819
0.16---------------8000---------------0.03901142
10-----------------8000---------------0.035761024

[MrShorty]

Can I assume you are already familiar with basic chart creation steps? https://support.office.com/en-us/art...rs=en-US&ad=US

ASsuming you already know how to create charts (a scatter chart specifically), the easiest approach might be to simply insert a blank row between the third and fourth row.

A more robust approach would rearrange the data in the spreadsheet, the create the scatter chart:

Please Login or Register  to view this content.