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!
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!
Comment