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.

Vi Editor shortcuts

dd	delete the line
u	Undo
U	Undo all changes on a line
CTRL+R	Redo
/	Search
n	Search the same phrase again
N	Search in the opposite direction
?	Search in backward direction(use instead of /)
CTRL+O	Go back to where we came from
CTRL+I	Go to newer position
%	Move the cursor to the matching parenthesis
:s/old/new/ge	Replace all occurrences of old with new
ge in above command	Find every occurrence in the whole file, with a prompt whether to substitute or not
CTRL+G	Displays your current location in the file and file status
G	Moves to the end of the file
<number>G	Moves to that line number
gg	Moves to first line
:!<command>	To execute a shell command from within the shell
v	Select line
:r!dir	Reads the output of the command and put it below cursor
y ->	Copies text (y -yank)
p ->	Pastes text (p -paste)
:set xxx	Sets search option xxx where options are: ic :- ignore case is  :- incsearch -->show partial search h|s :- highlight all matching phrases