ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I rotate a text box (https://www.excelbanter.com/charts-charting-excel/187-how-do-i-rotate-text-box.html)

Kent

How do I rotate a text box
 
I want to add text boxes to charts. The drawing toolbar does not allow me to
rotate the text box or text to fit the direction of other objects or text in
the chart. Is there a way to do this?

Bernard Liengme

Here's a workaround:
Make the text box;add the text; format lines and fill as needed
Hold SHIFT; use menu item Edit, select Copy Picture
Now use Paste
You have a 'photo' of the text box and this picture can be rotated with its
text

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Kent" wrote in message
...
I want to add text boxes to charts. The drawing toolbar does not allow me
to
rotate the text box or text to fit the direction of other objects or text
in
the chart. Is there a way to do this?




John Mansfield

Kent,

Instead of using a traditional textbox, another option might be to use
WordArt. You can use the WordArt toolbar to reduce the font size, color,
rotate the text, etc.

----
Regards,
John Mansfield
http://www.pdbook.com

"Kent" wrote:

I want to add text boxes to charts. The drawing toolbar does not allow me to
rotate the text box or text to fit the direction of other objects or text in
the chart. Is there a way to do this?



All times are GMT +1. The time now is 12:06 PM.

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