I have already asked questions regarding Pivot charts and I am still at a
loss, I have been told to run a macro to keep my color formats however I am
not much good at VBA. My chart is in a sheet underneath my pivot table and I
have been using
Private Sub Chart_Calculate()
With ActiveChart.SeriesCollection(3).Interior
.ColorIndex = 37
.Pattern = xlSolid
End With

the above to begin with but I know the private sub is in correct but what
should it be for a pivot chart?? also what does With
ActiveChart.SeriesCollection(3).Interior ??? mean I have looked on the
internet but is shows no examples and on this forum it only provides a link
to a support which doesnt give me any better indication.
Once i have resolved this I then also would like to know is it possible to
macro the chart for axis size as I am trying to compare two charts on the
same axis size.


Thanks
Kate