Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default how to stop resizing of font in a resized chart

when copying chart from Excel 2007 and pasting to Word 2007, and then
resizing upward that chart, the text in the chart grows disproportionately
large and makes the chart unusable (for me). What to do? Where is autoscale?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 70
Default how to stop resizing of font in a resized chart

When copying into WORD try the following (if you have not done this already):-

Edit / Paste Special / make sure Paste is selected / select Microsoft Office
Excel Chart Object / OK

Chart is now placed into WORD doc.

If you now single left hand click anywhere in the chart it will place a
double border around it.

On the top double line single left hand click the black square in the middle
(the second one in from the right hand side; the second of three) and,
keeping your mouse button depressed, enlarge the chart upwards (say by 2
cms).

Print Preview shows that text in chart still looks OK (it does not grow
disproportionately).

Hope this resolves your problem.




"Riri" wrote:

when copying chart from Excel 2007 and pasting to Word 2007, and then
resizing upward that chart, the text in the chart grows disproportionately
large and makes the chart unusable (for me). What to do? Where is autoscale?

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stop text box from resizing kh Charts and Charting in Excel 0 October 12th 06 09:14 PM
Stop a List Box from resizing Bob Excel Worksheet Functions 0 April 28th 06 08:46 PM
Resizing the font in a drop down list? dsu Excel Discussion (Misc queries) 1 January 10th 06 06:16 PM
Automation of Font Resizing Pitt Excel Discussion (Misc queries) 4 August 29th 05 11:28 PM
Automation of Font Resizing Mike Excel Discussion (Misc queries) 0 August 29th 05 09:50 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"