Infinite opportunities?  Endless problems?  Limited resources?  Talk to us!
Operations
Consulting
Software
Consulting
Publishing and
Training
Applied
Solutions
Excel add-ins
and tutorials
Charts Excel and VBA
Case Studies
VBA
tutorials
PowerPoint
Add-Ins
Miscellenia
You are on the Home/Excel/Add-Ins/Hover Chart Label page
About this site

What's new

Google
Web
This Site
 

 

Keywords: selective data label hover chart mouse pointer

This Excel add-in shows data labels in a chart only when the mouse hovers over the associated data point (or the label itself).

An added bonus is a 'Set data label' feature that links a worksheet range to a series data labels.

The compressed (zipped) file

Installation notes:  The zipped file contains one file, chart_hover.xla.  Extract to a folder (or directory) of choice.  From inside of Excel, add this file to the list of add-ins [Select the menu item Tools | Add-ins... | Click on the Browse button and select the chart_hover.xla file].

After clicking OK in the Add-ins... dialog box, the add-in will be active.

Hopefully, the function of the add-in is obvious as is how to use it, since there is no other documentation for it!

The motivation for this add-in comes from multiple requests in the Excel newsgroups and web formus.

 

The add-in adds the highlighted sub-menu as well as the menu item below it (i.e., 'Set Data Labels...')

The add-in uses chart events to perform its duties, particularly, the _MouseMove event procedure.  Consequently, it is called constantly by Excel whenever the active chart is under the control of 'Set Hover...'

This add-in has undergone limited testing with Excel versions 97, 2000, and 2002.  While I would like to fix all bugs that people find and add all the enhancements that people request, do remember that my (paying) clients get priority in my work schedule.

 

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com

[Optional] Survey (current rating of site: 3.7 out of 4)  If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

How do you rate the information

on this page?

  on this site?

[Optional]

Your name
Your email address
Other comments
 
Monitor page
for changes
    
   it's private  

by ChangeDetection
A comment selected at random:

 

 

Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited April 13, 2008