Values changing in a detached chart

[#1]

Hi - I have a bar chart that has a Text (Presentation tab) where I display the calculated Total value on the chart. I have a macro where I do an an attach, reload, detach of the chart, then a particular month is set - sub ReloadData ActiveDocument.GetSheetObject("CH22").Attach ActiveDocument.DoReload 0, false, false ActiveDocument.GetSheetObject("CH22").Detach ActiveDocument.GetField("Month").Select "Jan-09" end sub.

There are 2 issues: 1) after the reload, the detached chart shows values just for Jan-09. After the reload the chart values do not change even after manually selecting another month. Why does the chart change even after it has been set to Detach in the macro? 2) The text with the Total calculation keeps changing based on my selection on the sheet. How can I keep the text fixed as well?

Thanks.

[prieper]

Hi,

would be nice to have an example attached, anyway - is the document set to a particular month before the reload-command. In this case it would make sense to include a line like

ActiveDocument.Fields("Month").Clear

HTH

Peter

[#3]

That didn't seem to change anything. I do want to set my month to Jan-09 in the Macro, but not for the detached chart. Also, I have resolved my issue #2. Thanks.