Changing Border color of chart

[mellen]

Ok, I have a whole bunch of charts and I need to change the color of the x and y axis along with the outer border surrounding the graph.

I've been looking and haven't had any luck.

 

[RobBroekhuis]

You need to manipulate the colorindex property of the following objects:

activechart.axes(xlvalue).border
activechart.axes(xlcategory).border
activechart.plotarea.border

Rob

 

[mellen]

Ok, I tried and for the life of me, can't figure it out.

Here's my code
ActiveWindow.Visible = False
Windows("New Storage Graph.xls&quot.Activate
Range("G32&quot.Select
Sheets("New Charts&quot.Select

ActiveSheet.ChartObjects("Chart 9&quot.Activate

'Changing border color PROBLEM IS BELOW
ActiveChart.Axes(xlValue, xlSecondary).Select
With Selection.Border
.ColorIndex = 16
End With

ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 43
.Weight = xlThin
.LineStyle = xlContinuous
End With

 

[RobBroekhuis]

Share with us WHAT is not working! Are you getting an error? Nothing happens? From what I see, your code will
- change the color of the SECONDARY y axis (provided your chart has one, on the right of your graph)
- change the color of the first series plotted on your graph

Note that you don't need to select and then modify (even though that is what the macro recorder will produce) - it's quicker to modify directly, e.g.

activechart.seriescollection(1).border.colorindex=43

Rob