How do I prevent a text box from printing in XL2007?
in [Charts]
|
Prev: Excel 2007 crashing with simple scatter plots with 8 k data po
Next: Excel is adding 2 rows of data source together when charting
From: AndrewR on 24 Feb 2010 22:37 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? -- Andrew
From: Bernard Liengme on 26 Feb 2010 10:17 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" <AndrewR(a)discussions.microsoft.com> wrote in message news:48F49E19-8468-4F53-BA09-EF5D93FE31AC(a)microsoft.com... > 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? > > -- > Andrew
From: AndrewR on 1 Mar 2010 18:29 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" wrote: > 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" <AndrewR(a)discussions.microsoft.com> wrote in message > news:48F49E19-8468-4F53-BA09-EF5D93FE31AC(a)microsoft.com... > > 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? > > > > -- > > Andrew > > . >
From: Bernard Liengme on 2 Mar 2010 08:07 Is the text box 'grouped' to the chart? If so, it is treated as part of the chart best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AndrewR" <AndrewR(a)discussions.microsoft.com> wrote in message news:D0FE73E0-0E37-4E5A-B7D2-A50B2544781E(a)microsoft.com... > 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" wrote: > >> 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" <AndrewR(a)discussions.microsoft.com> wrote in message >> news:48F49E19-8468-4F53-BA09-EF5D93FE31AC(a)microsoft.com... >> > 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? >> > >> > -- >> > Andrew >> >> . >>
From: AndrewR on 2 Mar 2010 21:44
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. -- Andrew "Bernard Liengme" wrote: > Is the text box 'grouped' to the chart? > If so, it is treated as part of the chart > best wishes > -- > Bernard Liengme > Microsoft Excel MVP > http://people.stfx.ca/bliengme > > "AndrewR" <AndrewR(a)discussions.microsoft.com> wrote in message > news:D0FE73E0-0E37-4E5A-B7D2-A50B2544781E(a)microsoft.com... > > 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" wrote: > > > >> 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" <AndrewR(a)discussions.microsoft.com> wrote in message > >> news:48F49E19-8468-4F53-BA09-EF5D93FE31AC(a)microsoft.com... > >> > 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? > >> > > >> > -- > >> > Andrew > >> > >> . > >> > . > |