From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Create a moving average with a chart or by using a formula

Create a moving average with a chart or by using a formula - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create a moving average with a chart or by using a formula

“

- [Instructor] On this worksheet, we're seeing some data in columns A and B and a chart depicting that data along with what's called a moving average line. Sometimes it's important to see a moving average just as a line, but sometimes you want actual data associated with it. In this case, we're going to contrast both of those uses of the concept of a moving average. First of all, let's just create a brand new chart. I'll click on the existing chart, press delete, and click over in column A or B, makes no difference. All the data that we want to use is surrounded by empty cells and worksheet boundaries. So clicking within the data, we can simply press Alt+F1. That's the function key F and we automatically get a column chart. I'll resize this a bit. We don't need the actual title. Click on that, press delete, and at the bottom, make that a bit taller and so on. And ultimately we might change the look of the column width…

Contents