Bar Chart with text boxes and arrows doesn't print properly

[Kathy King]

Hi there! I have a user that creates lots of bar charts
and is spending countless hours trying to get his text
boxes with arrows to print properly. I have looked at
his files and they look great on the screen, however,
when printed the arrows are all out of whack. Any
ideas? I'm tearing my hair out trying to find the
answer.

Thanks in advance for any insight you can provide.

Kathy

 

[Jon Peltier]

Kathy -

Are these chart sheets? Set up a worksheet for printing in landscape
orientation, and figure out how much of it prints on a page. Then make
an embedded chart in the worksheet. Use the Alt key while dragging and
resizing the chart to glue its edges to the cell boundaries. Put the
text boxes and other graphics into this chart, then when it's time to
print, select the cell range underneath the chart, and print this range.
The chart doesn't do its resizing thing going from screen to printed
page, so the placed objects should move less.

Also, to nail a textbox to a given X,Y location in the chart, make a
dummy chart with a point at X,Y. Double click the point, format its
Patterns to be no line and no marker, then on the Data Labels tab,
select Show Value. Double click on the label, which is just showing the
value, and on the Alignment tab, choose the Center position. Then
select the text of the label and type your own text. Or select the
label, type =, and select a cell with the mouse, and the text in the
cell is now the text of the label. To make multiple labels like this,
make a multiple point series, and use Rob Bovey's Chart Labeler
(http://appspro.com) or John Walkenbach's Chart Tools
(http://j-walk.com) to apply a range of labels all at once. Both are
free add-ins.

- Jon

 

[Kathy King]

Thanks Jon, I'll give it a try and repost my results.

Kathy