Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can a color background on the screen be made to print white on pap | Excel Discussion (Misc queries) | |||
Print a data entry form without the spreadsheet as a background? | Excel Discussion (Misc queries) | |||
black background with white spots in the texture | Excel Discussion (Misc queries) | |||
Converted data to labels. The 0 in zip codes does not print | New Users to Excel | |||
can I print labels using data from an excell spreadsheet | Excel Discussion (Misc queries) |