Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Mac Excel 2008 - Update while sliding?
Greetings,
I mad a chart (in Excel 2003 on Windows) to analyze a fairly large set of scienctific data. The data evolves over time. In such a situation I like to create simple animations which show how the data evolves over time. I have done this many times using simple VBA macros. My problem now is that a colleague of mine uses a Mac and has Excel 2008 which is crippled w.r.t. VBA. My macro was just a simple time loop that updated the contents of a certain cell 10 times per second, after which spreadsheet formulas involving named ranges control what data is actually plotted. I read online that you could at least use form controls (but not Active-X controls) on the Mac version - so I made a different version of my spreadsheet with the macros deleted but with a slider (scroll) bar inserted and linked to a cell controlling the time parameter. The idea was to create a semi-automatic version where the animation is implemented by the user sliding the bar. It works quite nicely -- on Windows. It sort of works on the Mac - but the animation aspect (more or less the point of it all) doesn't work. The Mac version waits until the user releases the control before updating the chart so that if you slide through several animated seconds on the Mac the graph just lurches to the final state without displaying any of the intermediate states. I know almost nothing about Macs and even less about Excel on the Mac. Is there any way to get charts in Mac Excel to update in real-time? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days | Excel Worksheet Functions | |||
Sliding commission rates in excel | Excel Worksheet Functions | |||
(Fussball Spiel EM 2008) [2/3] - "Fussball Spiele EM 2008.par" yEnc (1/1) | Excel Discussion (Misc queries) | |||
Update 2007 calendar to 2008 | Excel Discussion (Misc queries) | |||
In Excel set up a sliding bar (similar to a volume control) | Excel Discussion (Misc queries) |