Create Dynamic Graphs in Excel

1. Convert each column of data into Table :

• Select a column then click Insert->Table

2. Define a name for first column.

• Go to to Formulas->Define Name and then give a name for the Table.

• For selecting the table just click on the header of the column.

3.Create a Drop-down list for selecting field for the chart

• Go to Data->Data Validation. In the Allow field select List.
• While selecting the source press F3 and then select the desired list (Table name given in step 2)

4.Create a row where data will change based on drop-down selection

• Select a blank row in the sheet for providing data for the chart
• Type the following formula

            =INDEX(<source data table column 1>,MATCH(<drop-down list cell location>,<source table of the drop-down list>,0));

5.Repeat step 4 for each column.

6.Make a chart and select the data source as this new data row.