From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Using Pick list, XLOOKUP, Table, and Chart together

Using Pick list, XLOOKUP, Table, and Chart together - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using Pick list, XLOOKUP, Table, and Chart together

“

- [Lecturer] As you work with Excel and become aware of its many features, there certainly are going to be times when you realize that some of those features can be used in combination. That by itself shouldn't be a goal, but in the worksheet that we're seeing here, we've got some data over in columns A through E, we're going to be using, first of all, a data validation pick list set up in column G, we'll be using the XLOOKUP function to pull in data, we also will convert our data... We'll also be converting data to a table and then base a chart on that. And one of the great features of a table is that as it expands a chart that might be based on it, and we do have that in this case, the chart will grow automatically. What we are showing in this worksheet are data from column D and E. And just as easily, we could have picked data from columns B and C. So the chart is showing percentage breakouts for the moment by…

Contents