View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] wendell_lucas@hotmail.com is offline
external usenet poster
 
Posts: 4
Default Data labels print with white background

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.ColorInde x = 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