From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Use formulas to create interactive charts

Use formulas to create interactive charts - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use formulas to create interactive charts

“

- [Instructor] This worksheet is a chart essentially empty, 2 although it is picking up data from January, 500. 3 As I click on the chart, you can see that it's designed 4 to pick up the data from columns A and B. 5 There's not a whole lot there at the moment, 6 but imagine your sales manager 7 is toward the end of a certain year. 8 You've analyzed the sales data for the current year 9 and you're about to make a presentation showing 10 projected sales for next year. 11 So as I click on cell B2, 12 imagine you've just put this in here 13 and you're talking about why you think that should be 500. 14 You provide your reasons, 15 then you can point to the lower right hand corner, 16 that's the fill handle. 17 We'll drag down into February to expose the February number. 18 And watch the chart. 19 Chart's going up, 750, and you provide the reasons for it 20 and talk as long as you need to on this particular topic. 21…

Contents