Add Label for XY Scatter Chart.zip

Objective

This macro can be used to automatically add/remove labels to scatter chart.

Instructions

1. Click "Place Labels on Chart" button on "XY Chart" sheet to put labels over the chart.

2. Click "Reset Chart" to remove labels (Must use this option after applying the labels). 



Functionality

1. Formatting of Scatter Chart (Applying Labels)

Note:- Attaching labels in XY Scatter chart is not possible in native "Office 2003/2007/2010".

2. For every scatter we have to create text box and then put the label.

3. In this macro labels part can be placed as automatically as per respective scatter points. (This macro can be used to automatically add/remove labels to scatter chart. (In excel to perform this action you need to add label to each point one by one).) 

Copyrights 2018, www.expertsupdates.com