Use formulas to create interactive charts

- [Instructor] This worksheet is a chart, essentially empty, … although it is picking up data from January. … 500. … As I click on the chart, you can see that … it's designed to pick up the data from columns A and B. … There's not a whole lot there at the moment. … But imagine you're a sales manager, … it's toward the end of a certain year, … you've analyzed the sales data for the current year, … and you're about to make a presentation … showing projected sales for next year. … So, as I click on cell B2. … Imagine you've just put this in here, … and you're talking about why you think that should be 500. … You provide your reasons. … Then you can point to the lower right-hand corner. … That's the fill handle. … We'll drag down into February to expose the February number, … and watch the chart. … Chart's going up. … 750. … And you provide the reasons for it, … and talk as long as you need to on this particular topic. … Notice that we have a heading up top, … Sales through February. … You come back at another point …