ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   automatically sizing text with graphs (https://www.excelbanter.com/charts-charting-excel/102441-automatically-sizing-text-graphs.html)

Shoque

automatically sizing text with graphs
 

hi, is there a way to make the text in my charts size proprotionally
with the graphs when i move them to another location (eg: a different
sheet or chart)....I seem to have a problem with the way the graphs
shrink but the text retaining their original size after i move them.


--
Shoque
------------------------------------------------------------------------
Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=566948


Office Helper

automatically sizing text with graphs
 
Right-click on the axis labels and choose Format Axis. Go to the Font tab
and make sure "AutoScale" is checked. This will need to be done for the
x-axis, y-axis, any titles and the legend.

"Shoque" wrote:


hi, is there a way to make the text in my charts size proprotionally
with the graphs when i move them to another location (eg: a different
sheet or chart)....I seem to have a problem with the way the graphs
shrink but the text retaining their original size after i move them.


--
Shoque
------------------------------------------------------------------------
Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=566948




All times are GMT +1. The time now is 11:51 AM.

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