Results 1 to 11 of 11

Interactive Chart Display

Threaded View

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    6

    Cool Interactive Chart Display

    I am trying to build a chart (and actually I want this to apply for all embedded charts on a certain sheet) that displays information in adjacent columns when I mouse down on a data point. Right, now I'm using a MsgBox to display xvalues and values. Ideally, when I click on point (x,y1) I will get a message with the point values and also the value of (x,a) [I do not want column a to be shown on the chart]. When I click on point (x,y2) [y2 is a series shown on the chart] I want to see the point value as well as the info in (x,b). Here is an example of how I have my data set up. [note: the headings are shifted. Column b is 68, 64, ... 59.] How do I do this?

    x y1 a y2 b
    500 30 88 32 68
    550 31 90 33 64
    600 32 72 34 101
    610 33 139 35 137
    620 34 134 36 59
    Last edited by exce; 08-27-2010 at 05:09 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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