Excel: Weather Underground Data and Line Charts

Описание к видео Excel: Weather Underground Data and Line Charts

This video shows collecting a month's worth of data from the Weather Underground site (wunderground.com) in order to plot (and eventually determine the statistical measures of) in Microsoft Excel. We copy/paste the data using "match destination", discuss the Excel cursors selecting versus fill handle, and show how to handle getting ####### as a result. We then use the temperature data to make a Line Chart, covering topics such as Chart Layout, Insert Symbol, High-Low Lines, Select data & naming Series, Date format, and ChartArea and PlotArea formatting.

Комментарии

Информация по комментариям в разработке