question

Harper-7125 avatar image
0 Votes"
Harper-7125 asked Harper-7125 commented

Excel Trying to make temperature vs. time graph but not coming out correctly

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?
119086-image.png


office-excel-itpro
image.png (38.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Harper-7125, this issued is related with Excel. Helped add the correct tag so that you would get help from the corresponding team

0 Votes 0 ·

Couldn't find it when I was making this so thank you.

0 Votes 0 ·
VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered VikiJi-MSFT commented

@Harper-7125,
Based on your description, I think you may need to re-select data for your chart.

  1. Please back up Excel file, and then remove and re-create a new Line chart.

  2. Select the chart, and go to Chart Deign tab, click Select Data.

  3. Edit Legend Entries and Horizontal Axis Labels as needed.
    119289-image.png

  4. Click Edit. In my test, I set the time column as the horizontal axis label.
    119304-image.png

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.


image.png (45.8 KiB)
image.png (35.9 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Harper-7125,
I am checking this thread, how is your issue going now?

0 Votes 0 ·

@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.

119935-image.png

119963-image.png
119869-image.png


0 Votes 0 ·
image.png (98.1 KiB)
image.png (25.9 KiB)
image.png (153.9 KiB)

@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.

119919-image.png

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:
120021-image.png

Any updates, please let me know.

1 Vote 1 ·
image.png (25.4 KiB)
image.png (46.9 KiB)
Harper-7125 avatar image
0 Votes"
Harper-7125 answered Harper-7125 commented

@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.
120302-image.png



image.png (15.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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!

0 Votes 0 ·

Got it, thanks again!

0 Votes 0 ·