Economic data visualization with Excel
Data visualization is an important tool for understanding and communicating information. Economic data can be complex and difficult to understand, but visualization can make it more accessible by simplifying the information and presenting it in a clear, intuitive format.
00:07 Macroeconomic data
00:28 Insert a bar chart
01:12 Select the correct data
02:30 Format the bar chart
03:21 Remove or add gridlines
03:49 Add or remove a trendline
04:15 Add data labels
04:41 Add axis titles
05:05 Remove chart labels
05:25 Histogram
05:51 Why use histogram?
06:41 Insert a histogram
07:35 Change the number of bins in a histogram
08:50 Change the bin width
09:28 Club data with bin flow
10:33 Formatting the histogram
11:55 Scatter plot
12:12 Insert a scatter plot
12:47 Add a trendline to the scatter plot
13:10 Chart two variables
13:55 Formatting the scatter plot
15:01 Pie chart
15:54 Insert a pie chart
16:08 Formatting the pie chart
16:32 Trend line
16:48 Insert a trend line chart
17:15 Select data in the line chart
17:48 Select label range
18:04 Formatting the line chart