Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced MS Excel charts with data optimization
I am doing a research paper on stock market volatility. I want to create a chart that lets the user customize the criteria for percentage moves in the stock market. The distribution chart is a histogram of shifts in the S&P 500 index. I want to create a chart where users can specify what percentage change occured in the market, and what the market did a specified amount of days after. I would like to create 2 buttons, one which let's the viewer change the percentage move in the market (from -10%,-9%...9%,10%), and one that let's the viewer change the the number of days (1-30) following that move to be displayed in the distribution. For example, I would like to the user to be able to customize the chart see the distribution of stock market moves 21 days after a 5% decline in the market, and easily change the criteria to see the distribution of market movements 5 days after a 2% increase. Changing these criteria with buttons would automatically update the graph. Any ideas how to do this -- cbalster ------------------------------------------------------------------------ cbalster's Profile: http://www.excelforum.com/member.php...o&userid=34855 View this thread: http://www.excelforum.com/showthread...hreadid=546063 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel spreadsheets with data, Powerpoint charts... and VBA! | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Why do OWC charts aggregate data when Excel doesn't? | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel |