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!
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!
