Charting in Excel via Lotusscript

HCL Domino Domino Forum
1

I have this nice little script that creates a pie chart from data in Notes. I have to choice of putting the chart in a new sheet (and the data in another sheet) or plonking it right in the middle of the data sheet.How can I move the pie chart with script?

I have fiddled with top and left but that does not seem to do much.

Preferably I would like to see this chart under my data?

Does anyone have an idea? Thanks

2

Subject: Charting in Excel via Lotusscript - IncrementLeft / top

Can you use something like this:

ActiveSheet.Shapes("Diagramm 1").IncrementLeft -165#

ActiveSheet.Shapes("Diagramm 1").IncrementTop 87#
3

Subject: RE: Charting in Excel via Lotusscript - IncrementLeft / top

But that is relative isnt it?