Results 1 to 6 of 6

How to assign a macro to a data point on chart

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Johannesburg, south africa
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to assign a macro to a data point on chart

    Good Day, I really hope someone will be able to help me.

    I am a nubee to macros and vb in excel and I would really appreciate the assistance.
    I have attached a excel worksheet that has a graph that plots dots, what I need to be able to do is to be able to click on the dot (data series) and for excel to navigate to another worksheet.

    The attached excel sheet has the graph on the first sheet and below it is the data it uses to plot.

    For some reason excel does not allow me to assign a macro to dot (data series) only to the graph which does not help me.

    Thanks
    Joey
    Attached Files Attached Files
    Last edited by joeyj; 07-06-2011 at 10:05 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1