Chart Manipulation

[ChartHelp]

I have code that:

1)runs a query
2)opens PPT and
3)generates a chart/graph based on those results

What I want to do is manipulate the resulting chart
(properties like lines, chart type, colors, etc...) from
Access. I have tried recording a macro in PPT but once the
chart is opened for edit the recorder doesn't record the
steps. I have also tried the template approach with an
existing chart but have not been able to generate the
chart with success. I know the chart can be set/changed
through code, but where is a good starting point? If I can
change the chart from Access instead of PPT it would be
easier. And I have considered passing to Excel and then
linking to PPT, but I'd really like to bypass Excel and
deal directly with the slide. Any suggestions?

 

[ChartHelp]

I've been able to progress some on this but still not what
I need. Any VBA assistance would be appreciated with
manipulating the chart object itself, from within Access
if possible. Thanks.

 

[ChartHelp]

Any takers?

-----Original Message-----
I've been able to progress some on this but still not what
I need. Any VBA assistance would be appreciated with
manipulating the chart object itself, from within Access
if possible. Thanks.




.