Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
trouble setting colors
I'd like to set the color of the datalabels for my series to be the
same as the series itself. The following does not work. It would seem that the color codes used by .interior.color of the series are different from those used for the font of a selection of a datalabel. Dim myChrt As Chart Set myChrt = ActiveChart Dim oSer As Series Dim dlabel As DataLabel Dim oSerColor As String For Each oSer In myChrt.SeriesCollection oSerColor = oSer.Interior.Color oSer.HasDataLabels = True For Each dlabel In oSer.DataLabels dlabel.Select Selection.Font.Color = oSerColor Next Next I'm using office 2007 btw. Thanks, Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically setting worksheet tab colors | Excel Worksheet Functions | |||
MY 2003 Excel does not show cell colors. Solution? Setting? | Excel Discussion (Misc queries) | |||
Setting colors of results in a column | Excel Discussion (Misc queries) | |||
having trouble setting page breaks on excel- have ms 2000 | Excel Discussion (Misc queries) | |||
Trouble setting total for on chart | Charts and Charting in Excel |