Hi,
More often than not the various solutions posted for manipulating charts in Excel 2007 with VBA are issue specific, which may be adapted by other users to suit their needs.
This is great, but often means trolling a large number of threads and posts before you find something you can use/adapt.

Given that chart methods are very difficult to track down and the VBA chart object model in XL07 isn't terribly helpful, and to possibly help users with basic manipulation I've started this thread in the hope that others will contribute snippets of code for making changes to charts in XL07 using VBA.

To start the code below can be used to make the chart border invisible for every chart in the active sheet. 

Sub Remove_Chart_Border()
' Use this to make the border on each chart in the active sheet invisible
'
' Get the number of charts in the active sheet
NumberOfChartsInActiveSheet = ActiveSheet.ChartObjects.Count
'
'Create a For/Next loop to cycle through each chart in the active sheet
For ChartLoop = 1 To NumberOfChartsInActiveSheet
'
'activate the next chart in the loop
ActiveSheet.ChartObjects(ChartLoop).Activate
' Do something with the active chart
With ActiveChart
' In this case the "do something" is set the line of the border of the Chart Area to invisible (visible = false)
    .ChartArea.Format.Line.Visible = msoFalse
End With
'
'move on to next chart in the loop
Next
'
'
End Sub
My knowledge of manipulating charts with VBA is very limited, so I'm hoping other (likely more experienced) forum members will see this as a good idea and tag on.