title: Add hover labels to a scatter chart that has it's data range updated dynamically in Excel 2007
body: <p>Hi I want to add labels to the plotted points on a scatter chart in Excel, however my charts data set range changes whenever my macro updates it... so my first question is: 
  Is there a way to set the data range of an Add-in such as the one below "Chart Hover Label" in VBA? </p>
  
  <p>Recording a macro did nothing (my fingers were crossed to begin with).</p>
  
  <p>Here is a list of other chart add-ins I know of, from what I know only 1 of these allows you to show ONLY the label when you hover over the plotted point.. I have also not seen one that allows you to show the data range on click of the point.</p>
  
  <p>This is the add-in that allows allows you to show only on the hover:
  <a href="http://www.tushar-mehta.com/excel/software/chart_hover_label/index.html" rel="nofollow">http://www.tushar-mehta.com/excel/software/chart_hover_label/index.html</a></p>
  
  <p>These are the other 2 I know of:
  <a href="http://www.appspro.com/Utilities/ChartLabeler.htm" rel="nofollow">http://www.appspro.com/Utilities/ChartLabeler.htm</a>
  http://spreadsheetpage.com/index.php/file/j_walk_chart_tools_add_in/</p>
  
  <p>Does anyone know of any other chart add-ins for Excel (preferably free) that give more options? and can be updated via VBA?</p>
  
  <p>Thanks for any help.</p>