Forum Discussion
Excel Novice: Need Help with Graphs
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.
3 Replies
It looks like datetime is just text which looks like datetime, not real date and time. Perhaps you may share the file?
- https://1drv.ms/x/s!AiSMrxTmZTpVkDrkZvAUz9-GEdxp?e=VTWVcq
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
