Thread
:
Changing the colour of a bar on a chart
View Single Post
#
2
Posted to microsoft.public.excel.programming
excelent
external usenet poster
Posts: 695
Changing the colour of a bar on a chart
try
ActiveSheet.ChartObjects(1).Activate
With chtChart
ActiveChart.SeriesCollection(1).Points(2).Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
End With
Reply With Quote
excelent
View Public Profile
Find all posts by excelent
Changing the colour of a bar on a chart