How to get graph data using Chart Events?

I have a Volume vs. Area plot. Here is the format of the worksheet

length | width | depth | Area | Volume

I would like to use chart events (Mouse Up event) to get me information about not only area and volume but also l, w, and d.

I know that following code give me info about x and y (i.e. area and volume.) But how to modify this code, so that I also get
"L= , W= , D= , A= , V= ."

Thanks in advance.

Please Login or Register  to view this content.

hi,

People often find it easier to help if they have a starting point to work from. Can you please attach a small example file (using the paperclip icon or the "manage attachments" button) showing your layout etc?

Rob

You would need to use the Arg1 and Arg2 values locate a cell within a known range.

See attached.

It assumes you know where the data table is located.

Please Login or Register  to view this content.