Current location - Trademark Inquiry Complete Network - Futures platform - How to draw a table similar to K line with excel?
How to draw a table similar to K line with excel?
This is not difficult.

1, expressed as hourly temperature value.

2. Enter the temperature value corresponding to 24 hours per hour in the current excel document (column input).

3. Select these 24 temperature values.

4. In the menu bar, select-Insert-Chart-polyline type (just like K-line chart)-The type of subgraph depends on your own preferences-Click "Next"-Select a column (make the temperature value on the Y axis)-Next (the title is up to you, the writing time (unit) on the X axis and the writing temperature on the Y axis)-Finish (at this time, select a new worksheet to insert or

5, so the form is basically formed.

If you are not satisfied with the progressive number of each cell, you can double-click the corresponding XY axis and select "Scale" in the property box to change it.

You can leave a message if you have any questions. I hope I can help you!

If you understand correctly, you mean that the temperature value corresponding to the point on the display coordinate should be displayed on the K line?

If so:

Everything else is the same as long as it is in the middle.

Icon Guidance-Step 3/4- Chart Options When you click on "Data Mark" and select "Value" from multiple options, you can satisfy your later question! ~ As for other options, you can choose to try it and see if it can strengthen the information in your chart!