fine tuning charts in VBA

[kobooky]

I handle charts from an access report and I want to
set the properties of the chart from VBA.
properties like line width, color, etc...
I need the same control of properties as you have in Excel charts dialog boxes.

I cannot find the syntax to reach this goal

Can someone help me with this?


Thank you in advance.

 

[dRahme]

Hi, try this as a starting point:

http://msdn.microsoft.com/library/en-us/vbagr10/html/grobjChart.asp

Hope that helps

 

[kobooky]

Thanks a lot!
This is a vary good source of information and I wasn't aware of it.

But I still have one probleme:
Lets say that I want to define the line color of the first series.
my report is called Rgraph
my chart object is called Graph1
Rgraph.Graph1..... does not work!

How do I refer to the chart in the VBA code?
my guess is that once this is solved I would be able to use the data in the above link.

thank you.

 

[hermanlaksko]

If you make some breakpoint in your code (F9) then you could, via the locals window, (found via view, locals wondow), see all oprions for any subject or element in this window. It should bring back on track.

Herman
Say no to macros