Repositioning Chart Elements with the Mouse

You can move the chart title, axis titles, data labels, and legend by dragging them with the mouse. You can also use your mouse to explode a pie slice or doughnut bite. Note, in particular, that you can adjust the positions of individual data labels without moving an entire series of labels; in addition, although Excel creates legends in certain fixed positions, you’re free to drag them anywhere you like, even to the middle of the chart.

To restore the default position of an object immediately after you move it, press Ctrl+Z. To restore its initial position later, delete the object, and then re-create it.

Unfortunately, although you can move data labels at will, you have no such freedom with the tick-mark ...

Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.