China Naming Network - Feng Shui knowledge< - Please help me, I want to make a line chart of weather forecast in EXCEL table, but I don’t know how to make it.

Please help me, I want to make a line chart of weather forecast in EXCEL table, but I don’t know how to make it.

In your data, there is only a specific temperature in °C on March 7th, and all °C is empty from March 8th. How to generate a chart?

Also, the temperature on March 7 is the daily minimum and maximum two numbers (7°C~13°C) combined to form a text format. It cannot be used as a chart value. The two numbers must be combined first. separate. For example, March 7 (column C):

Generate the lowest temperature:

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

Generate maximum temperature:

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

< p> Then use these two sets of temperatures to generate a graph.

上篇: Seek a good day for getting married on 20 12! ! ! ! ! ! Ask professionals for advice! ! ! ! 下篇: I dreamed of a ghost calling my door and calling my name.