Here's an example.
Sheet 2 shows a table with data pulled from sheet 1. The values in column A are selectable via data validation and the values in the subsequent columns populated via Index/Match formulas.
The graph on the 'Composite' sheet utilizes the table on sheet 2.
Let us know if you have any questions.
Bookmarks