Data labels print with white background

[wendell_lucas]

Hi,
I am writing a macro to create a xlColumnStacked ChartType. I'm asking
Excel to show the series values inside the column wthout borders or
fill:

For i = 1 To .SeriesCollection.Count
.SeriesCollection(i).ApplyDataLabels AutoText:=True, LegendKey:=
_
False, ShowSeriesName:=False, ShowCategoryName:=False,
ShowValue:=True
.SeriesCollection(i).DataLabels.Border.LineStyle = xlNone
.SeriesCollection(i).DataLabels.Interior.ColorIndex = xlNone
Next

The graph looks exactly as I would expect: with the values within each
column stack and the column colors as the background. But, when I
print, the data lables all have white backgrounds. This shows in print
preview as well.

The Format Data Label wizard shows Area Fill = None but the white
color selection box is selected. Is there any way to show the column
colors through the data label?

Thanks,
Wendell

 

[Jon Peltier]

Add this statement:

.SeriesCollection(i).DataLabels.Font.Background = xlTransparent

- Jon

 

[wendell_lucas]

Add this statement:

      .SeriesCollection(i).DataLabels.Font.Background = xlTransparent

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______










- Show quoted text -

Thanks, Jon
Works fine. You have a great site too! This is just one more line of
your code in this application.

Wendell