how to show another column when hovering on a point in a chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to show info from another column when you hover on a point in
a chart?
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point in the little
popup box.

thanks,

Wei
 
Hi Tushar,
Got your add_in from your site, thanks.
But don't know what to do with it. When I select "Set Hover" from the TM
drop-down, it only asked me to select chart, then nothing happens after I
selected one.
I'm using excel 2003 on XP.

Wei
 
First, you have to set data labels for the series (use TM | Set data
labels...) This is a function similar to, but simpler than, the one in
Rob Bovey's XY Chartlabeler add-in (or John Walkenbach's Chart Tools).

Then, select TM | Datalabels on Hover > Set Hover... Now, specify the
chart.

If done correctly, the datalabels will shrink to a font size of 1. The
size will be reset to 10 with TM | Datalabels on Hover > Reset Hover...

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top