Spider_Cant_007.wmv

Toggling Data Series with various mouse-click/keyboard combinations There are 13 videos loaded under the heading "Excel Spider Charts". Please click on "Excel Spider Charts" for a text summary of what is available. There is nothing special about spider ("radar") charts; I could have used bar charts, line charts, pie charts. The videos show a variety of tasks implemented on mouse clicks throughout the chart. There is nothing special about the actions I have chosen; they tend to be oriented to changing the appearance of the charts. They could as easily be "Launch a browser", "Fire off an email" or "Start a real-time analysis of 4,500 TSX companies using financial statements from Google Finance". The number of events that can be trapped is not infinite, but it is bigger than anything any client could dream up. We can detect a mouse click, and the 8 possible combinations of Shift/Ctrl/Alt. We can detect a click on an object, and since we can read off the x-y coordinates of the mouse, we can calculate our position within any suitable large object. There is nothing special about dividing the legend block (or chart area or plot area) into 2x2=4 quadrants; they could as easily be divided into 3x3, 2x3, 4x5 etc providing the areas are large enough for the user. My biggest hurdle with the client will be getting them to dream up actions that they want to take; they will be using Excel as a presentation medium.