LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default vba chart xlValue axis title truncated, one series name omitted

1. Instead of a period as the last character, use a non-breaking space
(ascii character 0160), which needs no font color adjustment.

2. You should try very hard to find a 2D chart that shows what you want. 3D
charts are more complicated to build, and they present the data in a way
which most readers find more difficult to understand.

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


"chet" wrote in message
ups.com...
Oops. That first line of code for the first problem should read

.Characters(<titlelength-1, 2).Font.Color = vbWhite

As erroneously specified, it would just recreate my original problem
through a different mechanism.

chet





 
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
Y- AXIS LABEL IS TRUNCATED in EXCEL CHART ? rama Charts and Charting in Excel 0 October 25th 06 08:28 AM
Text Truncated on Vertical Chart Axis Label Adrian Excel Discussion (Misc queries) 1 October 20th 05 11:50 AM
Truncated "y" axis label in chart flakkortin Charts and Charting in Excel 10 August 4th 05 08:53 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM
The x-axis title is truncated in EXCEL charts 2003. Bernard Liengme Charts and Charting in Excel 0 November 26th 04 05:25 PM


All times are GMT +1. The time now is 07:50 PM.

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

About Us

"It's about Microsoft Excel"