VBA to remove color from a datalabel???

[Lidsavr]

I am running Excel 2003.

I've searched all of my reference books, this forum and the internet and cannot find an answer.

I know I can add color to a data label background (interior fill) with the following code:

ActiveChart.SeriesCollection(1).DataLabels.Interior.Color = RGB(108, 108, 108)

I cannot figure out how to write the code so the data label fill color is 'none'. (I've tried "None" and the data label fill color becomes black).

Does anyone have any suggestions or a line of code to do it?

Many thanks,

Charles

 

[VoG]

Maybe

ActiveChart.SeriesCollection(1).DataLabels.Interior.Color = RGB(255, 255, 255)

 

[Lidsavr]

VoG,
I forgot to add that the datalabels are centered on a red column. My mistake. The code you gave me makes the background 'white', which ends up enhancing the problem, not eliminating it. The best way to describe what I want to do is when you eliminate the color in 2007 manually, you would click format labels - fill = no fill.

I have seen a lot of your posts and you are one of the best code writers on the forum. Do you have any other suggestions?

Thank you,

Charles

 

[VoG]

Have you tried xlNone

 

[roscoe]

Resurrecting an old thread (since I had the exact same question), xlNone made a funky light blue. My only working solution was to not assign a color until I knew I wanted it.