Skip to Content

How do I create a chart from a multiple Vlookup where the variable is based on something i select?

Jan 25, 2017 at 04:43 AM


avatar image

Hi, i have a bar chart and I would like to have the user click on on of th bars for it to provide an adjacent chart with more detail about the item (the day) they just clicked.

So, I have the spreadsheet that has dates down the lefthand side, and values in column B. Some of the dates are duplicates, i.e. jan 4 shows 4 times with a diffrent value in column B. I need all 4 values to show up, not just th first one from the vLookup, so i created an array in .xls. This delivers all of the data in column B for the givn date (jan 4.)

When i preview, i get an error that Excell doesnt support th Row function. Any othr ideas on how to show this data?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers