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