Dynamic Graphing Utility

[DustinMechEng]

Hello All-

I am looking for a data plotting utility like Excel that allows the user to make dynamic, zoomable plots like those on Google Finance like this:

http://finance.google.com/finance?q=INDEXDJX:.DJI INDEXNASDAQ:.IXIC INDEXSP:.INX

I have a large set of data that needs to be reviewed, but can't all be displayed on a graph at one time. Any suggestions?

Thanks for the help!

 

[MintJulep]

Somewhere I have some VBA code that allows you to move two cursors along the x-axis and zoom in between them.

Not nearly as slick as the Flash stuff in your link.

 

[electricpete]

I have built a few different interactive graphs for data in some of my spreadsheets.

One fairly simple one uses embedded chart and works primarily off the worksheet change event to change cells labeled Xmin, Xmax, Ymin, Ymax (which directly changes the chart limits). Also a button for panning left/right by user-selectable amount and a toggle button for linear/log.

A more complicated one allows the user to select points. But it's behavior seems a little flakey still.

Both are embedded in large spreadsheets. I will try to unbundle the simple one and post it this weekend.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[electricpete]

Here is the simpler spreadsheet I discussed:

http://home.comcast.net/~electricpete/eng-tips/PlotInteractiveR2.xls

See instructions tab. Let me know if questions.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[electricpete]

Here is another version, with documentation slightly improved:

http://home.comcast.net/~electricpete/eng-tips/PlotInteractiveR3.xls

Thanks to joerd for helping me figure out how to scale the data for plotting, without creating another copy of the data.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[DustinMechEng]

electicpete-

Thanks for the chart. Its not exactly what I was looking for but it is really nice and will help me until I can find what I am looking for.

Thanks a bunch!