Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the colour of a bar on a chart
I have created a column chart and am now trying to change the colour of one
of the bars. Here is the code I am using: With chtChart ActiveChart.SeriesCollection(1).Points(2).Select With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With End With But to an avail. can anyone see what is wrong with it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the colour of a bar on a chart
That code should work though "With chtChart..End With" does nothing in your
useage. You don't need to select the chart With ActiveSheet.ChartObjects(1).Chart .SeriesCollection(1).Points(2).Interior.ColorIndex = 3 End With Regards, Peter T "Graham Whitehead" wrote in message ... I have created a column chart and am now trying to change the colour of one of the bars. Here is the code I am using: With chtChart ActiveChart.SeriesCollection(1).Points(2).Select With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With End With But to an avail. can anyone see what is wrong with it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing background colour when changing data in a cell | Excel Discussion (Misc queries) | |||
Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
Changing default chart settings like background colour etc | Setting up and Configuration of Excel | |||
Permanently changing default chart settings like gridlines and background colour | Charts and Charting in Excel | |||
Maintain colour changes in a Pivot Chart when changing Pivot value | Charts and Charting in Excel |