Noob with the ubiquitous "format pivot chart" question

This question has been posted everywhere and I think I've read through dozens of posts if not a hundred. I too have a multi-axis pivot format that I would like to apply to a pivot chart. I have recorded the following macro:

Sub Format_axis()
'
' Macro recorded 8/23/2006 by Mr. Magoo
'

'
ActiveChart.SeriesCollection(2).Select
ActiveChart.SeriesCollection(2).AxisGroup = 2
ActiveChart.Axes(xlValue, xlSecondary).Select
Selection.TickLabels.AutoScaleFont = True
With Selection.TickLabels.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 3
.Background = xlAutomatic
End With
ActiveChart.SeriesCollection(2).Select
With Selection.Border
.ColorIndex = 3
.Weight = xlThin
.LineStyle = xlContinuous
End With
With Selection
.MarkerBackgroundColorIndex = 3
.MarkerForegroundColorIndex = 3
.MarkerStyle = xlSquare
.Smooth = False
.MarkerSize = 5
.Shadow = False
End With
ActiveChart.Axes(xlValue).Select
Selection.TickLabels.AutoScaleFont = True
With Selection.TickLabels.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 5
.Background = xlAutomatic
End With
ActiveChart.SeriesCollection(1).Select
With Selection.Border
.ColorIndex = 5
.Weight = xlThin
.LineStyle = xlContinuous
End With
With Selection
.MarkerBackgroundColorIndex = 5
.MarkerForegroundColorIndex = 5
.MarkerStyle = xlDiamond
.Smooth = False
.MarkerSize = 5
.Shadow = False
End With
End Sub

The problem lies in the fact that I am just now starting to learn VBA but as always, the boss needs this done ASAP. I have external data from an Access database feeding the pivot table and linked pivot chart. I want the chart to run this macro everytime a combo box is changed in value.

Where do I apply this? The worksheet? The workbook? The chart object? I'm new to VBA code also so an explanation of the major parts of the VBA code would really help a lot. Thanks to anyone who can help me on this...I'll be sure to reciprocate for the next guy asking this question...