January 2007
Intermediate to advanced
1008 pages
32h 43m
English
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 ...
Read now
Unlock full access