Hi ,

Is it possible to store the offset values to an dynamic array and then transfer array to an named range....so that i can use it as my chart data source.

Please Login or Register  to view this content.

I want to use legendarea.Offset(0, 1).Value = strLegend(indlegend) as my Y axis value and legendareanum.Offset(0, 4).Value = counter / Actualrows * 100
as my X axis value.....I need to plot a Stacked 2D bar chart using this values.But as these ranges are dynamic,i thot to store in a array and then copy over to one fixed range.


have also posted at http://www.ozgrid.com/forum/showthread.php?t=157897
but couldnt get any reply.....

Regards
Ashesh