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
Bookmarks