Pivot Chart Issue

[zappa007]

I've created a PivotChart on my form, which works nicely. However, I would like to be able to format the PivotChart Field and save those changes.

For example, I change the "team" to a blue circle. When it requeries, it sets it back to the default.

Does anyone know how to change the defaults or save the changes?

thanks

 

[Simplycongy]

Bump... I now have a similar problem.

I have a pivot chart with turnover on one axis and profit on the second, using . But when I requery the pivot chart it removes my series groups and plots them both on the same axis! Any ideas?

 

[EddiRae]

I have my formatting in the load of the form. Here is what I have when I load the form.

Private Sub Form_Load()
Dim c As ChartSpace

'Set the Chart data.
Set c = Me.ChartSpace

c.SetData chDimCategories, chDataBound, strCategory
c.SetData chDimCategories, chDataBound, strCategory
c.SetData chDimValues, chDataBound, strData

c.Charts(0).Axes(0).HasTitle = True
c.Charts(0).Axes(0).Title.Caption = strCategoryCaption
c.Charts(0).Axes(1).HasTitle = True
c.Charts(0).Axes(1).Title.Caption = strValueCaption


If (strGPSLoss = "all" Or strGPSLoss = "") And (strLossType = "all" Or strLossType = "") And (strLoss = "all" Or strLoss = "") And (strReason = "all" Or strReason = "") Then
c.SetData chDimFilter, chDataBound, "Line"
' c.SetData chDimSeriesNames, chDataBound, strSeries
c.SetData chDimSeriesNames, chDataBound, DAvg("[GPS Loss]", "qryDowntime")
Else
c.SetData chDimFilter, chDataBound, strSeries
c.SetData chDimSeriesNames, chDataBound, "line"
End If
End Sub

The data is on the form and will load with the pivot chart