A macro to change formatting of 27 graphs

[yabi100]

I have 27 graphs in 27 sheets in an excel file. I want to perform exactly similar changes in all 27 graphs, like bringing the axis labels from middle to low, add border line and few more formatting changes. Is there any Macro solution to write and apply to all 27 sheets at once? I have very small knowledge of Macro programming but I think it would be possible. I can record steps in one sheet but I don't know how make do loop to extend it to all remaining sheets?Will be happy to guide me how to amend/write this Macro.

 

[DanteAmor]

I have 27 graphs in 27 sheets in an excel file.

You could give an example of a sheet with data (use XL2BB tool) and the graph. If the data is sensitive, change it to dummy data.
Put an image of how the graph is before the macro.

I can record steps in one sheet

Now record the macro with what you want to do to the graph.

Put here the code generated by the recording and also the image of the resulting graph.

With all of the above I will try to help you make the cycle for all the sheets and their graphs.

 

[yabi100]

You could give an example of a sheet with data (use XL2BB tool) and the graph. If the data is sensitive, change it to dummy data.
Put an image of how the graph is before the macro.



Now record the macro with what you want to do to the graph.

Put here the code generated by the recording and also the image of the resulting graph.

With all of the above I will try to help you make the cycle for all the sheets and their graphs.

Thanks Dante
Let me prepare the requested material and I will send them.