View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Petr Prikryl Petr Prikryl is offline
external usenet poster
 
Posts: 2
Default 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)