Chart Manipulation

  • Thread starter Thread starter ChartHelp
  • Start date Start date
C

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?
 
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.
 
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.




.
Click to expand...
 
Back
Top