Stars :
Status : Offline
Join Date: 09 Oct 2007
Posts: 7
Posted:
Mon Oct 15, 2007 3:46 pm Plotting graphs - Save this post
I've looked around and can't find a whole lot of information regarding the plotting of spreadsheet data. More specifically, is it possible to have a swf look to a spreadsheet and animate the growth of the data across a bar graph?
Needlesstosay, this could be extremely beneficial...but I'm not sure if this is even possible.
If you have thoughts on the direction that I should take please don't hesitate.
A correction to the above: there is no way to automatically export a swf. So, if not a swf then is there any way to automate the animation of a growing graph whose positions would be dictated by the different values of a spreadsheet?
For anyone interested, I have settled on using the following to graph information based on spreadsheet data (this is great stuff; however, I had to forgo the animated idea- at least for now):
Data Validation Lookup-- Select a level from a dropdown list, then enter a minimum and maximum value in adjacent columns. The values are constrained by the limits set in a lookup table on another worksheet.Select a clipart item from a data validation dropdown list, and that picture appears in the adjacent cell. Uses Worksheet_Calculate event code. Sample file from Bernie Deitrick.
--------------------------
Ian_smith
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
