Charts Format Question

[moi2185]

Hello guys, quick question related to charts. I have a couple of charts which are referenced to some pivot tables, I run a macro to display one at the time by hidden the others and so on. Everytime when I run the macro the charts are displayed but the data label format is lost (always back to automatic black). Is there any way to maintain it? Basically I need to keep some of the data labels in white after hidden or unhidden the charts.

Any help is apprecciated.

Best regards,

Moises G.

 

[RoryA]

You will probably need to add some code to your macro to reformat the datalabels.

 

[moi2185]

You will probably need to add some code to your macro to reformat the datalabels.

can I use the record option to get the code? or should I need to write it down?

Thanks!

Moises G.

 

[RoryA]

Try recording it and see.