ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Printing a Chart with a Text Box (https://www.excelbanter.com/charts-charting-excel/180509-printing-chart-text-box.html)

cap

Printing a Chart with a Text Box
 
I am trying to print out a chart with a text box labeling a specific data
point. If I select the entire sheet to print, the data, the chart, and the
text box will print. However, when I select only the chart to print (which
is what I want), the text box remains with the sheet, and does not appear
with the chart.

I believe this is an issue with "background/foreground", so I grouped the
chart and the text box together, but this still did not work.

Is there any advice out there? Thanks.

Jon Peltier

Printing a Chart with a Text Box
 
You didn't add the textbox to the chart, you added it to the sheet. If you
print only the chart, it does not include the text box. Cut the text box,
select the chart, and paste. Now the text box is part of the chart. Move it
where you want it. Next time you need a text box associated with a chart,
select the chart, then click on the text box button.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"CAP" wrote in message
...
I am trying to print out a chart with a text box labeling a specific data
point. If I select the entire sheet to print, the data, the chart, and
the
text box will print. However, when I select only the chart to print
(which
is what I want), the text box remains with the sheet, and does not appear
with the chart.

I believe this is an issue with "background/foreground", so I grouped the
chart and the text box together, but this still did not work.

Is there any advice out there? Thanks.





All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com