Hello again.
I'm using a macro to chart a set of data. I'm also creating multiple charts.
How to I move the chart to a certain cell? Shape objects have a "TopLeftCell" property but it's read-only.
I would like to be able to move the top left corner of chart 1 to "$A$1", chart 2 to "$A$100", and so on.
Thanks,
-Tim
I'm using a macro to chart a set of data. I'm also creating multiple charts.
How to I move the chart to a certain cell? Shape objects have a "TopLeftCell" property but it's read-only.
I would like to be able to move the top left corner of chart 1 to "$A$1", chart 2 to "$A$100", and so on.
Thanks,
-Tim