Linking a data validation list

[ACrossley1]

Hi.

I have produced a very large table with approx 15 rows and a column for each day.

I have also made a line graph for this table.

I obviously dont want the very large table on show, as it would look not good if it is above or below the graph.

Therefore, I am wanting to link another drop down list to the table so that it automatically changes the graph when i click it.

Thanks.

Adam.

[dflak]

This sounds like it could be done with named dynamic ranges. It would help a lot if you could attach a workbook with some sample data. It is difficult to visualize how you have your data laid out without it. Also it's more likely we can give you a specific solution for your setup rather than a general answer that you would have to figure out how to apply.