PDA

View Full Version : How to position a chart?



chamster
09-10-2007, 02:28 AM
I've created a chart but it's being popped out "at random" or at least not where i'd like it to be. I've created a macro for moving but that didn't give my much pleasure. How do i create a chart and then position it at
a) 100x175 (just an example)
b) exactly in the corner of cell G6 (still, just an example)

rory
09-10-2007, 02:42 AM
You can use something like:
activesheet.chartobjects(1).top = range("G6").Top

and then similarly for Left.

chamster
09-10-2007, 02:52 AM
Splendid! Thanks!