View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Excel 2003: How to nudge a chart element or shape on a chart?

Hi Ted,

Actually you can. With the text box selected

1. Display the Drawing toolbar - View, Toolbars, Drawing
2. Choose the command Draw, Nudge and pick one of the directions

To make the process easier, when you choose Draw, Nudge note that there is a
gray bar at the top of the submenu, put your mouse over that gray bar and
drag the Nudge toolbar away from the Draw menu. This way you can float the
Nudge toolbar and quickly and easily use it.

--
Cheers,
Shane Devenshire


"Ted M H" wrote:

Hi Andy,

Thanks for the response. I was afraid this was the case, but didn't want to
leave the assumption untested.

"Andy Pope" wrote:

Hi,

I don't think so. As you point out cursor keys move between elements
rather than re-position them.

Other than using the mouse the only way would be via code. Creating a
user form to allow you to select the shape to move and buttons to adjust
the position.

Cheers
Andy

Ted M H wrote:
I'm looking to determine whether or not it's possible to nudge a selected
chart object or a shape or text box that's been added to a chart. When I add
a text box or other shape to a worksheet I select it and then use the arrow
keys to nudge it around. In Charts, however, the arrow keys are used for
selection rather than moving.

So the question is: Is there a way to nudge chart objects for precise
placement on the chart?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info