Precisely position a chart in Excel

5

1

When making a chart in the worksheet (not an independent chart sheet), is there a way to position the chart a little more precisely? Instead of just leaving it there "floating"?

I have a bunch of tables, one under another, and every table is going to have its own chart. Is there a way when I copy the first one, under the second one (just change the data) to make them exactly one under another ... not "wiggling" left/right?

I have Excel 2007.

Rook

Posted 2010-04-03T21:28:53.860

Reputation: 21 622

Answers

7

Hold down the Alt key on Windows (Cmd on Mac) when you move/resize charts to make them snap to the nearest row/column boundary.

Mike Fitzpatrick

Posted 2010-04-03T21:28:53.860

Reputation: 15 062

Snaps to the centre of a row/column also, which is perfect for me needs. – David Gard – 2015-08-07T15:30:33.083