Move a chart object with arrow keys

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.

Excel Tips - Move a chart with arrow key.png

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… 

Here’s HOW:

  1. Add another shape (any shape like a line, a rectangle, a circle, a textbox, etc.) to the sheet.
  2. Select your chart together with the shape (by holding Shift key while clicking the objects).

Excel Tips - Move a chart with arrow keys.png

Now you are ready to move your chart by pressing arrow keys.

As simple as that.🙂

This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

2 Responses to Move a chart object with arrow keys

  1. Adrien says:

    Or you can simply press ctrl while clicking the chart in the first place🙂

    Like

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s