Need a code to my macro to change format of a chart

[bazofio]

Hi guys

I have this macro to make a automatic chart and give me some values from the data i have (average, sum, min and max).

What i need is a code to insert in this macro that allows me to change the format of the chart. For example i need to change the type of letter in the axes, the size, if its bold or not, colour, etc, etc. All this is to change in the code itself.

This is the code:

Please Login or Register  to view this content.

Thanks in advance

[AlphaFrog]

For example i need to change the type of letter in the axes, the size, if its bold or not, colour, etc, etc.

Too vague.

I would suggest you record a macro and you manually make all the changes to the chart. Then the recorded macro could be edited and integrated into your main macro, but that would provide the base code to start from.

[bazofio]

Thanks AlphaFrog for your reply.
I already try that but then i dont know where to put the code from the recorded macro in the existing macro. Can you help me out on where should i place it.

Thanks in advance

[AlphaFrog]

Thanks AlphaFrog for your reply.
I already try that but then i dont know where to put the code from the recorded macro in the existing macro. Can you help me out on where should i place it.

Thanks in advance

Post the code of your recorded cart formatting macro.

[bazofio]

Here it is a example:

Please Login or Register  to view this content.

So now i dont know where do i put this code in the one that i have without breaking it.
Thanks for the help ;-)

[AlphaFrog]

Please Login or Register  to view this content.

[bazofio]

Thanks AlphaFrog.

Perfect