If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart & annotations pasted to Microsoft Word
I use lots of annotoations (text boxes, auto shapes, etc..)on my Excel
charts. Typically these charts are then pasted to Word. When I reposition the chart within Word, the annotations do not follow. Soes anyone know of a way to "lock" the annotations within the chart so when I reposition the chart, the annotations move with it? Thanks, Bill |
#2
|
|||
|
|||
Chart & annotations pasted to Microsoft Word
Bill -
There are two issues that may be working here. First, if the added graphical elements are not part of the charts in Excel, they will be harder to control. If the shapes disappear when you select the chart, they are floating over the chart in Excel's drawing layer but are not integral to the chart. When adding such elements, make sure the chart is selected prior to clicking the button for the shape. Another issue is that text boxes and other elements are not associated with XY positions in the chart. If the labels are resized, or the fonts change size, etc., they will reposition to fit. For text labels, you could use a dummy series with invisible points where you need a label, apply a data label to the invisible points (show value or label, doesn't matter), and edit the label text. This quickly gets tedious, so you'll appreciate one of these free add-ins that automate the process" Rob Bovey's Chart Labeler (http://appspro.com) John Walkenbach's Chart Tools (http://j-walk.com) - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Bill B. wrote: I use lots of annotoations (text boxes, auto shapes, etc..)on my Excel charts. Typically these charts are then pasted to Word. When I reposition the chart within Word, the annotations do not follow. Soes anyone know of a way to "lock" the annotations within the chart so when I reposition the chart, the annotations move with it? Thanks, Bill |
Thread Tools | |
Display Modes | |
|
|