Traditional Culture Encyclopedia - Weather forecast - I want to make an EXCEL chart of weather forecast, but I don't know how to do it.
I want to make an EXCEL chart of weather forecast, but 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.
- Related articles
- Which Chinese hamburger is the best in Xi 'an?
- Near-surface weather system in the northern hemisphere
Question 1:A
Question 1:A
Question 1:D
This topic examines the effects of isobar readings and weather systems.
Ques
- Weather forecast of Hengyang in May 1 day
- Only one egg is released a month? How does a woman's body feel when she begins to ovulate?
- How to download Vibrant Knight?
- Wild survival skills
- How long does the resurgence weather usually last?
- Intermittent failure of BMW physical keys in cold weather.
- Is Zhao Temple in Zuo Qi, Bahrain open this year?
- Will it snow before 65438+1October 30th in Zhangjiajie? If it snows in Zhangjiajie, will it snow in Tianmen Mountain?