using the pivot table feature can anyone help
 

i cant seem to figure out how the pivot table works, i have data in the form
of share prices, name and date.....i need to put this info in the form of a
chart/graph that continuously updates itself as i update the data. if anyone
can help.....please do.....