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

Question

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

Harper 26

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?

MichaelHan-MSFT 18,136 Reputation points

2021-07-30T01:34:04.467+00:00

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

2021-07-30T02:06:42.89+00:00

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

Answer accepted by question author

Viki Ji_MSFT 4,476

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

Viki Ji_MSFT 4,476 Reputation points

2021-08-02T09:11:26.437+00:00

@Harper ,
I am checking this thread, how is your issue going now?
Harper 26 Reputation points

2021-08-02T18:22:14.797+00:00

@Viki Ji_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.
Viki Ji_MSFT 4,476 Reputation points

2021-08-03T01:47:59.677+00:00

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

2 additional answers

Your answer

MichaelHan-MSFT 18,136 Reputation points

2021-07-30T01:34:04.467+00:00

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

2021-07-30T02:06:42.89+00:00

Couldn't find it when I was making this so thank you.
Viki Ji_MSFT 4,476 Reputation points

2021-08-02T09:11:26.437+00:00

@Harper ,
I am checking this thread, how is your issue going now?
Harper 26 Reputation points

2021-08-02T18:22:14.797+00:00

@Viki Ji_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.
Viki Ji_MSFT 4,476 Reputation points

2021-08-03T01:47:59.677+00:00

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

Answer 1

Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can create one using this free template: Gantt project planner template for Excel
Microsoft 365 subscription offers premium Gantt chart templates designed to help you track project tasks with visual reminders and color-coded categories. If you don't have a Microsoft 365 subscription or the latest Office version
To create a Gantt chart like the one in our example that shows task progress in days:
Select the data you want to chart. ...
Click Insert > Insert Bar Chart > Stacked Bar chart.
Next, we'll format the stacked bar chart to appear like a Gantt chart. ...
If you don't need the legend or chart title, click it and press DELETE.

Answer 2

Harper 26

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

Viki Ji_MSFT 4,476 Reputation points

2021-08-04T05:42:31.287+00:00

@Harper ,
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!
Harper 26 Reputation points

2021-08-04T17:40:59.31+00:00

Got it, thanks again!
Lihini Weerakkody 0 Reputation points

2023-08-22T22:55:35.4333333+00:00

Could you please tell me how you did it? I want a same type of graph (time vs temperature )

Share via

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

2 additional answers

Your answer