Hi,
Images and shapes etc I can move around using the keyboard keys (left, up, down, right arrow keys etc).
However when trying to do the same with charts it just selects the different parts within the chart. I've tried to hold in CTRL + arrow key etc. But nothing seem to work.
Can anyone help? Please don't tell me it isn't possible...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
On the other hand, you can just drag it with the mouse.
Entia non sunt multiplicanda sine necessitate
One way to line up a chart perfectly is to hold down the ALT key while dragging it. This way the chart will snap to the cell grid.
You can also select several charts and use the "Align or Distribute" command from the Drawing toolbar (under the Draw menu) to help you align several charts at once.
Press the Select Object Tab on Drawing Tool Bar and move chart with arrow keys .........................
Where do I find the Select Object Tab on Drawing Tool Bar in Office 2007?
When you select a single chart 2007 you get the enlarged border selection and directions arrows will move you through the chart elements.
There is a selection tool. Home > Editing > Find & Select.
But again this enables the enlarged border.
If you select more than 1 chart and or shape you can use the cursor keys to move the group selection.
As suggestioned you can use the ALT key to snap to grid when dragging the chart with the mouse.
You can with code select the active chart such that the cursor keys will work.
Try this in the Immediate window. ALT+F11 CTRL+G
Please Login or Register to view this content.
I had to exactly align several graphs and had the same problem. The mouse is just too ruggid for really exact alingment.
Solution is simple:
- Just insert some shape (a circle, or something) next to the graph or chart you want to move.
- Group the graph with the shape and voila, you can move them with cursor keys.
Holding the 'Ctrl' key increases movement resolution even more. When your done aligning, just ungroup the chart and the shape, and delete the shape or use it for the next thing you want to align.
cheers
1) ctrl + x (Cut)
2) Go to the cell you want. (ctrl + arrows for faster movement)
3) ctrl + v (Paste)
The top left edge of the graph will be aligned to the top left of the cell selected.
I have the same problem all of a sudden and I am going bonkers. It was working just fine, I could press ESC until the entire graph is selected and then move with arrows. All of a sudden I can no longer do that. Has anyone found a solution, I am desperate. I have a 50 page ppt with a 100 line graphs on it...((((
m_rad,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks