Editing charts on Access forms with VBA

I

ilo

I am trying to programatically edit the appearance of a chart in ms access. I
wish to press a button on the form and have a corresponding series change
colour or thickness or whatever, but I can't seem to get anything to work!
The chart object class in MSGraph.Chart.8 and has the name 'graph1' in the
form. The chart type is an x-y scatter with lines connecting the points. When
I use the code me.graph1.seriescollection(1).line.color I get an error saying
'object doesn't support this property or method", but the help files indicate
that it should. I have been able to get a couple of the properties to work
(axisgroup seems to be ok), but not most of them. Please help!

Also, can I add a 3rd y-axis onto the chart at all?

many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top