Macro/VBA Help

[john62290]

I have the following script run to edit the data points in a chart in excel. How can I make this dynamic for each point in the chart?

As it works right now, it will only change the label for that one particular point. Is there a way this macro can run so when any point is selected, the script can be run to make the edits:

Below is what is written so far:

Sub DataTab()
'
' DataTab Macro
'

'
ActiveChart.FullSeriesCollection(17).Select
ActiveChart.FullSeriesCollection(17).ApplyDataLabels
ActiveChart.FullSeriesCollection(17).DataLabels.Select
Selection.Format.TextFrame2.WordWrap = msoFalse
Selection.Separator = " "
Selection.ShowSeriesName = True
End Sub

Thank you for your help!