Possible to Add Horizontal Line to Embedded Graph via VBA?

[tschwaar]

Hello -

We have an Access 2000 database (don't leave yet!) with a report that is
basically just an embedded (OLE) graph object. It is a simple line graph,
based on an Access pivot query, showing three lines (series) with numerous
data points.

We want to add a horizontal 'target' line to this graph so people can see
the data relative to a target. Manipulating the underlying data is difficult
only because there are quite a few similar reports, each with complex
queries. We had hoped to manipulate the graph/chart directly from VBA by
adding an additional series with our own target value as the data.

Our problem is our inability to add a series. The Chart object, Series,
SeriesCollection, etc. don't have an Add method. An approach I've seen in a
few examples (after LOTS of Google searching) involved the .NewSeries method
but that produces an error message indicating an unknown method.

Is our approach completely wrong? Is it even possible to add another series
to an existing chart? Thanks for any help.

Tim Schwaar

 

[Tushar Mehta]

Also check the responses to the multipost in .excel.programming.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Hello -

We have an Access 2000 database (don't leave yet!) with a report that is
basically just an embedded (OLE) graph object. It is a simple line graph,

{snip}