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