I need an interactive chart page in Excel 2000 which will allow me to manipulate a set of data (all the same size, X columns by Y rows, the data size will need to be able to be manually respecified, but will not change dynamically) with drop down boxes which will allow me to show or hide lines, change the range of data displayed, etc. The code must be clear and flexible enough to accomidate changes in formatting. Specifics will be communicated to winning bidder. I will try to be more specific, but feel free to tell me what info. you need: I have a number of different sets of historical stock price information. I will be using this information to derive basic statistical trends (mean, median, Std. Dev., etc.) and will be looking at this information over different time periods (1, 3, 6, 12, 60 months) and against other stocks. I figured I could use the standard excel static graphs and make a new graph everytime I want to look at something new (or keep pages with every different iteration of graph) or I could have a standard grapher made which would allow me to look at this data interactively on one page (I would like one page which allows me to see one graph full page, and another which fits 4 or 6 different graphs). That way, I can choose to see company X over a 6 month period along with the trend line of its standard deviation compared to company over the same period with the trend line of its average, and could then change my mind and choose to see the two companies over a 3 month period, etc.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
## Deadline information
Would like to have it by beginning of next week.