ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Title - exceed maximum length? (https://www.excelbanter.com/charts-charting-excel/161793-chart-title-exceed-maximum-length.html)

Geoff C

Chart Title - exceed maximum length?
 
Excel 2003 - there appears to be a 255 character display limit on a
referenced chart title. Is there a way to exceed this? One of my chart
specifications has a title 373 characters long.

Bernard Liengme

Chart Title - exceed maximum length?
 
If there was a way to exceed it, then it would not be the limit.

There is a workaround - use two text boxes for the title
Unless you are using XL2007;
-use the tile for the first part of the text
-click the chart, type the second half of text; hit Enter key
-drag resulting text box to required position
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Geoff C" wrote in message
...
Excel 2003 - there appears to be a 255 character display limit on a
referenced chart title. Is there a way to exceed this? One of my chart
specifications has a title 373 characters long.




Andy Pope

Chart Title - exceed maximum length?
 
Hi,

No you can not exceed the limit.
You can however use a textbox instead. Or use another title element, such as
the y-axis title to hold the extra words.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Geoff C" wrote in message
...
Excel 2003 - there appears to be a 255 character display limit on a
referenced chart title. Is there a way to exceed this? One of my chart
specifications has a title 373 characters long.




All times are GMT +1. The time now is 08:24 PM.

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