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

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
_______


wrote in message
...
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

On May 6, 2:48*pm, "Jon Peltier"
wrote:
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
_______

wrote in message

...



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.ColorInd ex = 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- Hide quoted text -

- 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