View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sunryzz Sunryzz is offline
external usenet poster
 
Posts: 10
Default Pivot chart question

I have a pivot chart that refreshes with a Macro and uses a user defined
chart format with a light blue background. The weird thing is that when it
refreshes, the background of the data labels changes to white and I have to
change them all back to transparent. When I first created these reports,
this didn't happen, but sometime in the last few months it started to do
this. Has anyone else seen this phenomenon and/or does anyone have a
suggestion of how I can keep my data label backgrounds transparent?

Thanks