Chart to worksheet programmatically -- coordinates?
"Petr Prikryl" wrote:
[...] how can I get the coordinates
where visually the cells from range (say) "H4:J20" sit?
"K Dales" wrote...
A Range object has Top, Left, Width and Height properties that correspond
directly to the same properties in the ChartObject. So (assuming you have
set the variable ChartRange to equal the range you are interested in
filling):
Excel.ChartObject chartObj = charts.Add(ChartRange.Left, ChartRange.Top,
ChartRange.Width, ChartRange.Height);
[...]
Thanks, it works fine!
Thanks also to Tom Ogilvy who answered similarly.
Petr
--
Petr Prikryl (prikrylp at skil dot cz)
|