Feb 14 2022 11:11 AM
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.
Feb 14 2022 11:47 AM
It looks like datetime is just text which looks like datetime, not real date and time. Perhaps you may share the file?
Feb 15 2022 01:15 AM
You return data by Power Query. Add one more step - right click on datetime column and select Change Type Using Locale
Here DateTime and English US
For the Measure assign Decimal Number type.
Remove errors, load to the sheet and add scatter chart, format axis as desired