setting rowsource for chart control using Basic code

G

ge liu

HI,

I try to set the rowsource for chart control (the MSGraph
2000 chart), but found out the basic does not take it.
Later by debug.print the perperties of the chart control,
I found out that the rowsource and rowsourcetype are not
even listed as among the properties. Yet according the
the online help, rowsource and rowsourcetype are
properties of a chart and should be able to be set using
basic code. Plus, rowsource and rowsource properties are
in the property box and can be set menually. Is this some
kind of bug? or is there something I do not know?

If anyone know how to solve it, and able to shed some
light to me, I am greatly appreciate it.

Ge
 

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

Similar Threads

change chart rowsource at run time 2
Iteratively referring in code to a chart name that varies 2
Combo box rowsource based on another combo box 3
Error setting Rowsource using VBA for Chart 3
Set Rowsource property for Chart Control using VB code 7
how to set the rowsource for a chart using viusal basic code? 0
Setting control value based on a SQL Select statement 12
Change row source in vba, and later revert to original 1

Top