Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers