I want to make a broken line in the EXCEL table of weather forecast. I don't know how to do it.

Your data is only the specific temperature c on March 7, and it has been empty since March 8. How to generate a chart?

In addition, the temperature on March 7th is the lowest and highest daily number (7℃~ 13℃) combined to form a text format, which cannot be used as a chart value, so separate the two numbers first. For example, March 7th (column C):

Minimum generation temperature:

=-LEFT(C2, find ("~", C2)-3)

Maximum generation temperature:

= - SUBSTITUTE(RIGHT(C2，LEN(C2)-FIND("~ "，C2))，" C "，)

Then use these two sets of temperatures to generate a chart.