If you do chart in Excel, you may have encountered this: You clicked on a chart object, tried to move it just a little bit to the right by pressing Right Arrow key a few times… Instead of the chart being moved to right, different chart elements were selected one by one with each press of the arrow key.
OMG… How come it is so difficult to perform such a simple task?
There is a simple trick (although imperfect) to let you move a chart by using arrow keys…
- Add another shape (any shape like a line, a rectangle, a circle, a textbox, etc.) to the sheet.
- Select your chart together with the shape (by holding Shift key while clicking the objects).
Now you are ready to move your chart by pressing arrow keys.
As simple as that. 🙂