... on your more general question, I am self-taught in macros, which means I'm quite good at some stuff and hopeless at others. I'd recommend proper training if you're likely to use them regularly. To get started, I'd suggest using the macro recorder while you are performing simple actions (typing in formulas, copying etc) then looking in the VBA area (Alt+F11) to see how Excel records what you have done. This will get you started on how the syntax and commands operate, and basics like objects, properties and methods.
This website is also very good for hints and explanations.
The macro above is a simple one. It says that, for each series in the active chart, apply data labels and then apply the format you specified.
When I was getting started I found a good tip is to record the actions you want to perform and then add a bit of code to set conditions on how to apply it where and how you want. For example in your case, I would select a series in the active chart and record the process of formatting it. Then I'd add the code
above that code, and
below to apply it to each series in the chart.
you would also need to tweak the macro by replacing "selection" with "ss" so it doesn't only format the selected series.
Bookmarks