Excel 2007 Chart with text box

[BlueHorizon]

Hi all!

I have a client who uses Excel 2007 to create charts and then puts text boxes on the chart to add comments. When this is printed on 8.5 x 11, it prints great. But they often print the chart on 24 x 36 paper for presentations. When they do, the chart columns "grow" to fit the larger paper, but the text box contents do not, i.e., it remains at 14 pt.

Any suggestions? What they have done (and it works pretty well) is copy/paste to PowerPoint 2007 and print from there. Then everything expands to fit the larger paper size. But if I could save them the extra steps, won't I look good?

Hmmmm....Thanks in advance for any help!!


Best,
Blue Horizon

 

[xlhelp]

Is size with Chart Selected?

Are the objects grouped together?

Unfortunately, I only have access to a regular printer so I can't test anything.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[BlueHorizon]

Thanks, xlhelp!
Yes, "size with chart" is selected.

It seems in 2007, I'm unable to group anything with a chart. Group options are grayed out, and I'm unable to select both the chart and the text box.

Hmmmmm

Thanks!

Best,
Blue Horizon

 

[xlhelp]

If the Group option is greyed out, that would mean that they are already grouped.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents