Hi Stew

This is a problem with Pivot Charts.
The way around it, is to record a macro as you do the formatting.
Then copy the macro, and place it within a Chart activate event. See the
example below. The code that you record with the macro recorder, will go
within the section I have noted to apply to the particular formatting you
want.

Copy the code in it's entirety after you have created your section>right
click on the chart sheet>View Code>paste the code into the white pane. Press
Alt+F11 to return back to Excel.
Then, whenever you return to the chart, your formatting will be re-created.

Private Sub Chart_Activate()
On Error Resume Next
Application.ScreenUpdating = False

'' your code will start here
ActiveChart.SeriesCollection(1).Select
   With Selection.Border
       .ColorIndex = 9
       .Weight = xlMedium
       .LineStyle = xlContinuous
   End With
   With Selection
       .MarkerBackgroundColorIndex = xlNone
       .MarkerForegroundColorIndex = xlNone
       .MarkerStyle = xlNone
       .Smooth = False
       .MarkerSize = 3
       .Shadow = False
   End With

'' your code will end here
         ActiveChart.ChartArea.Select
   Application.ScreenUpdating = True
   On Error GoTo 0
End Sub