By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,080 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

How to make a dynamic chart with vlookups?

P: 26
Hi everyone. I'm trying to make a chart that tracks peoples positions in a leauge over a time period. The thing is I need to have a couple of different charts for the same people over the same time periods but for different things.

So for example John, Paul, George and Ringo and I all sell tomatoes, car stereos and life insurance. I want to show their ranking on each product over a quarter. But rather than having three graphs I've heard that I can have one chart and it's data can change based on a drop down using Vlookup.

I have 3 tables. All the same names, with the same weeks. All that changes is the peoples positions (1-5) week on week. How do I use a Vlookup to alter the chart's information? I've included a screenshot of the spreadsheet in case I've not been clear.

Thanks in advance!
Attached Images
File Type: jpg bytes.jpg (68.9 KB, 474 views)
Nov 3 '10 #1
Share this Question
Share on Google+
1 Reply


maxamis4
Expert 100+
P: 295
Take a look at this link:

http://chandoo.org/wp/category/excel/
Nov 20 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.