Hello Friends

Please refer attached file. I need to add a drop down menu in the graph which shows the place names and as soon as I select the anems the graph should update. place names are shown in Column A of "Share Summary" sheet in the file

Also I would need to make the date columns absolute as I will keep on adding months to the exisiting file as time goes forward, so when I add months, the graph should also automatically show the new added columsn.

I am using excel 2003


If you could provide a a basic step by step, will be greatly appreciated.


Regards,
Excel Dumbo