How do I prevent a text box from printing in XL2007?

[AndrewR]

In XL2003 I could put a text box on a chart and mark it to NOT print with the
chart. Having upgraded to XL2007 I can't find how to do that and previous
(2003) spreadsheets that had non-printable text boxes now print those boxes
in XL2007.

Can anyone help, please?

 

[Bernard Liengme]

Right click the txt box; select fro popup menu "Format Shape"
In left hand panel; select "Properties"
In lower half of dialog, uncheck "Print Object"
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

 

[AndrewR]

Bernard,

Thank you for your reply. That is certainly true when I place a text box on
a worksheet but when it is on a chart the "Print Object" option is not
available; not greyed out, just not there.

Andrew

 

[Bernard Liengme]

Is the text box 'grouped' to the chart?
If so, it is treated as part of the chart
best wishes

 

[AndrewR]

Bernard,

It is not grouped to the chart. If I create a text box on a worksheet I see
the "Print Object" checkbox; if I cut it and paste it to the chart that
option is gone. Put it back on the sheet and it's there. It certainly appears
that this functionality has been removed in going from XL2003 to XL2007.

 

[Bernard Liengme]

I followed what you did: cut and paste a text box to a chart
I agree that the Print boxes have disappeared in the Properties dialog of
Format Shape
However, this method also groups the box and the chart - if I move the chart
the box moves with it so they are grouped
If I use the command Insert | Text box and draw the box over the chart, then
I get a box that is not grouped and I can set the print properties. Note
that the chart must NOT be selected before you draw the box as this will
group the two.
best wishes

 

[Bernard Liengme]

I should also have said: rather than cut & paste the text box into chart,
you can also drag the box over the chart, and the two will not be grouped.
best wishes

 

[AndrewR]

Bernard,

Thanks for your help. I think I see my problem; I have created the chart on
a separate sheet, rather than on the data sheet. I copied my chart to the
data sheet and, sure enough, I can put a text box on it. However, I still
can't move the chart AND the text box to a new sheet, so I will have to find
out how to work with it on the data sheet. Probably not a problem but it's
annoying that I could do this in 2003 but not now. Oh well, never mind.

Again, thanks.