Hello all, currently I am attempting to plot temperature vs. time. However, whenever I try to plot my data, it keeps coming out like below. How can I fix this?
Hello all, currently I am attempting to plot temperature vs. time. However, whenever I try to plot my data, it keeps coming out like below. How can I fix this?
@Harper-7125, this issued is related with Excel. Helped add the correct tag so that you would get help from the corresponding team
@Harper-7125,
Based on your description, I think you may need to re-select data for your chart.
Please back up Excel file, and then remove and re-create a new Line chart.
Select the chart, and go to Chart Deign tab, click Select Data.
Edit Legend Entries and Horizontal Axis Labels as needed.
Click Edit. In my test, I set the time column as the horizontal axis label. 
Besides, I found this Customize charts Video, you could also have a look.
Hope the information could be helpful to you. Any updates, please let me know.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
@VikiJi-MSFT I attempted to use your solution, but for some reason my temperature values are not working when I try to select them. After I highlight the column, it just says =1 instead of listing all the values in the graph. Is there a simple way to just select the x and y values for the graph? Below is what I'm seeing at every step.



@Harper-7125,
Thanks for your reply and sharing.
Due to the particularity of recording temperature and time as numerical values, Excel will display numerical values as data in the chart by default.
If the first column of the table is text, such as abc, you may not have this worry. I added the ℃ symbol after the temperature value, and directly generated the chart shown below.

In this case, if you want the temperature value as the x-axis, you may need to manually uncheck the temperature under the Legend Entries tab, and click Edit under the Horizontal tab to select all the values under the temperature column. As shown in the second picture in my first reply.
My test: 
Any updates, please let me know.
@VikiJi-MSFT This worked and I finally got the graph I wanted. Thank you very much for taking your time to help me figure out my problem, I really appreciate it.
@Harper-7125,
I am glad to hear that your issue has been resolved.
Could you please accept the useful information as an answer, this action will help other users who have the similar issues on this forum.
Thanks for your understanding!
4 people are following this question.