Join Dennis Taylor for an in-depth discussion in this video Using Pick list, VLOOKUP, Table, and Chart together, part of Excel Tips Weekly.
- View Offline
- By combining different Excel features,…you can come up with a presentation model…like the one we're about to see.…We're gonna be using a Pick list, the VLOOKUP function,…the table capability and charting.…In the list of data that we see off to the left,…we've got some of the major States listed,…Houses Sold, Cars Sold for a given year.…We'd like to display this as a chart.…And we want to make it dynamic.…Let's start with the idea that…the State entry in cell E2,…that we're gonna put in initially,…should come from a Pick List.…
Now Pick Lists are part of what we call data validation.…Let's image, for the moment, what we're about to see…is a Pick List here that will let us…select a state, then we'll use a VLOOKUP function…to show the houses sold and the cars sold.…We'll have this converted into a table…and then base a chart on that information.…And one of the advantages to using a table for a chart…is that if we happen to add data,…and we might want to do that,…the chart will grow automatically.…So let's start with a Pick List idea.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.