Chart Alignment - Excel - Dynamic Range

[LoneWolf_2106]

Hi everybody,

i have a question about Excel, i have to create several charts one below the other dynamically.

I have thought to use:

 

$oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell)
$iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count

 

And then to use it in this way:

$Graph_position = "=Test1!A"&$iRowCount+2&":K"&$iRowCount+24

But it doesn't work with charts.

Does anyone have a suggestion?

 

[water]

You could have a look at the ExcelChart UDF. Function _XLChart_ChartCreate allows to specify the cell range to use for a chart.
For download please check my signature.