Excel Novice: Need Help with Graphs

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3164689%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20Novice%3A%20Need%20Help%20with%20Graphs%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3164689%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello.%20I%20am%20trying%20to%20create%20a%20line%20graph%20that%20shows%20the%20change%20in%20pressure%2C%20rpm%2C%20and%20flow%20rate%20over%20time.%20I've%20been%20trying%20to%20use%20the%20graph%20tool%20that%20Excel%20has%2C%20but%20I%20am%20not%20getting%20what%20I%20want.%20Any%20help%20or%20suggestions%20would%20be%20appreciated.%20I%20have%20attached%20a%20snippet%20of%20the%20info%20I%20am%20trying%20to%20graph.%20Thanks.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348148iB445FDB66444451E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screenshot%202022-02-14%20141009.png%22%202022-02-14%3D%22%22%20141009.png%3D%22%22%20alt%3D%22Screenshot%202022-02-14%20141009.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348149i9F72C0F5A061D853%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screenshot%202022-02-14%20141108.png%22%202022-02-14%3D%22%22%20141108.png%3D%22%22%20alt%3D%22Screenshot%202022-02-14%20141108.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3164689%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Hello. I am trying to create a line graph that shows the change in pressure, rpm, and flow rate over time. I've been trying to use the graph tool that Excel has, but I am not getting what I want. Any help or suggestions would be appreciated. I have attached a snippet of the info I am trying to graph. Thanks.

 

Screenshot 2022-02-14 141009.png

Screenshot 2022-02-14 141108.png

3 Replies

@zjlwms 

It looks like datetime is just text which looks like datetime, not real date and time. Perhaps you may share the file?

@zjlwms 

You return data by Power Query. Add one more step - right click on datetime column and select Change Type Using Locale

image.png

Here DateTime and English US

image.png

For the Measure assign Decimal Number type.

Remove errors, load to the sheet and add scatter chart, format axis as desired

image.png