Make a line chart that represents the temperature across several blocks of two hours.
- First you’ll need some temperature measurements for different times throughout the day.
- Highlight the frequency table you’ve created and choose
Insert from the top menu bar in
Excel. Then select
line chart from the
Recommended Charts menu. If an appropriate line chart doesn’t appear, choose from the
Line Chart menu next to the
Recommended Charts menu.
- This line chart looks pretty good already. To make it even clearer, you can add the axis title "Time" for the horizontal axis. You can also add different chart elements to customize it like you want, for example change the color of the line, or change range of temperatures to display along the vertical axis.
The final line chart should look like this: