change ColumnCount in MS Graph Object with VBA

[Stefan]

Hi NG!

I included a MS Chart Object in one of my Access forms. The MS Chart
Object has a property called "ColumnCount" which defines the amount of
data rows that should be displayed in the line chart.

The problem I'm facing is, that I need to change this property with VBA.
The data source is generated on runtime and can contain a variable
amount of data rows.

However, if I try to change this property I always get the following
runtime error:

2448: You can't assign a value to this object

I can read the value, but how can I change this Value?


Stefan

 

[AL-MURISI]

Hi NG!

I included a MS Chart Object in one of my Access forms. The MS Chart
Object has a property called "ColumnCount" which defines the amount of
data rows that should be displayed in the line chart.

The problem I'm facing is, that I need to change this property with VBA.
The data source is generated on runtime and can contain a variable amount
of data rows.

However, if I try to change this property I always get the following
runtime error:

2448: You can't assign a value to this object

I can read the value, but how can I change this Value?


Stefan