Refer to Data point in charts

[#1]

Hi

How do you refer to certain data points within a certain expression in a chart.

Any help would be appreciated.

Thanks

[#2 · Accepted solution]

Hi

Just to give an update I have used the following code which refers to the cells.

sub

chartloop

set

obj = ActiveDocument.GetSheetObject( "CH2" )

set

cp = obj.getproperties

For RowIter = 1 to obj.GetRowCount-1

set

msgbox (cell.Text)

cell = obj.GetCell(RowIter,1)

next

sub

[#3]

Hi

Just to give an update I have used the following code which refers to the cells.

sub

chartloop

set

obj = ActiveDocument.GetSheetObject( "CH2" )

set

cp = obj.getproperties

For RowIter = 1 to obj.GetRowCount-1

set

msgbox (cell.Text)

cell = obj.GetCell(RowIter,1)

next

sub