DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Excel Macro for selecting and plotting graphs

  1. #1
    Join Date
    Jul 2006

    Excel Macro for selecting and plotting graphs

    Hi there, I'm not particularly familiar with macros in XL although I have done some work in VB before. I am wanting to create a simple interface for a user with minimal fuss. I have 3 columns of data - X, Y and a unique ID. There are more than one set of X,Y coordinates for each ID and at least 20 different IDs. I would like to have a form appear when excel opens which displays in a box each id and the user can then select one or more which can then be displayed in a single graph for visual comparison.
    I would be very very grateful for anyone who can take a little time to help me out.

  2. #2
    Join Date
    Feb 2004
    Colton, CA
    The best place to start for VBA (visual basic for applications) - is to record macros and edit them to extract the code you require.

    For example, put some data onto a sheet and hit record macro.

    Do the functions you'd like your application to perform, then stop the macro and examine the code.

    You can then cut & paste, and manipulate as necessary.

    It works for me anyway

  3. #3
    Join Date
    Jul 2006
    Thanks - although the problem is that there could be a combination of 100+ different graphs to be plotted. Can anyone tell me how to select the ID of items selected in a list box ....

Similar Threads

  1. plotting simple graphs
    By matt_5104 in forum Java
    Replies: 3
    Last Post: 03-02-2005, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center