Charts Format Question

moi2185

New Member
Joined
Apr 4, 2009
Messages
47
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You will probably need to add some code to your macro to reformat the datalabels.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Try recording it and see. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,335
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top