That behaviour is unavoidable. The graph exists in an embedded Excel object and depends on data that are held in the worksheet behind it. The fact the data are sourced from Access is immaterial.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|