From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Creating an automatically expanding chart by basing it on a table

Creating an automatically expanding chart by basing it on a table - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Creating an automatically expanding chart by basing it on a table

“

- [Instructor] On this worksheet are two sets 2 of identical data. 3 I'm going to be creating a chart from each of them, 4 but for the second set of data, starting in row 12, 5 I will first convert that into a table. 6 If you base a chart on a table, 7 whenever the table expands, the chart expands automatically. 8 But in the first case up here, I'll simply create a chart 9 without having converted the data to a table. 10 Because the information is surrounded by empty cells, 11 we don't even have to highlight the data, 12 we can simply click within it 13 and instantly create a chart 14 with the keystroke combination Alt+F1. 15 And that F1, of course, means the function key F1. 16 Alt+F1. We've got a chart. 17 Now, I've just gotten data, imagine, for June 18th. 18 I'll click on cell A8 19 and drag that lower right hand corner downward. 20 Automatically, we'll get the next day in there. 21 Nothing has happened on the…

Contents