changing charts properties using VB

D

dshemesh

Hello,
I have a report wiht a chart (Microsoft Graph 9.0 Object). I want to change
some properties of the chart dynamically when the report opens using VB (like
whether the chart should show values above the bars, and whether the values
would be in precentage or absolute values). I think I know generally how to
do it, but the problem is I don't know the name of the properties I want to
change (that is, the name under VB).
Does anybody know where I can find a reference with all the names of the
proerties of a microsoft Graph?
thank you
 
D

Duane Hookom

I think there have some good posts in the past that you might find by
searching google. I create a similar chart in Excel and turn on the macro
recorder. Then I modify properties like I want my code to do in Access. Stop
the macro recording and view the code created in Excel. You can copy, paste,
and modify the code in your Access report.
 
D

dshemesh

thanks!
--
dshemesh


Duane Hookom said:
I think there have some good posts in the past that you might find by
searching google. I create a similar chart in Excel and turn on the macro
recorder. Then I modify properties like I want my code to do in Access. Stop
the macro recording and view the code created in Excel. You can copy, paste,
and modify the code in your Access report.
Click to expand...
 
Top