×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Dynamic Graphing Utility

Dynamic Graphing Utility

RE: Dynamic Graphing Utility

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.

RE: Dynamic Graphing Utility

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.

RE: Dynamic Graphing Utility

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.

RE: Dynamic Graphing Utility

(OP)
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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources