Issue with Saving Straight Chart

[balrammahato204]

Hi All,

Please help me on below

I want to compare my straight chart data with source QVD data. I do not  want to save the chart data into QVD and then do the comparison.

Is there any way so i can save my chart data on UI and i can compare the all data with Source QVD data.

Thanks and Regards

Balram Mahato

[balrammahato204]

I got the sample macro from the community where i can capture the data for a specific row and column. Is there any idea if i can modify this macro and can take the whole column data.

Sub ChangeV1

set table = ActiveDocument.GetSheetObject( "TB01" )

CellRect = ActiveDocument.GetApplication().GetEmptyRect()

CellRect.Width = table.GetColumnCount

CellRect.Height = table.GetRowCount

set CellMatrix = table.GetCells(CellRect)

r = Activedocument.variables("r").Getcontent.String

c = Activedocument.variables("c").Getcontent.String

set cell = CellMatrix.Item(r).Item(c-1)

Activedocument.variables("v1").SetContent cell.text,1

End Sub