Thanks for your continued support.
(I swear that the "Jon" was there when I hit the Send key.)

Dave Peterson wrote:
Cher, Madonna, Peltier.

(or did someone snip too much out of her response? hehehe)

(Jon, Jon, Jon, Jon, Jon -- in case you need extra for you next post.)

oh, oh.



Debra Dalgleish wrote:

Peltier has some information on this in his Charting FAQ article:

http://pubs.logicalexpressions.com/P...?ID=209#jon025

and at his web site (use this updated link instead of the one in his
article):

http://peltiertech.com/Excel/Charts/FixFonts.html

Toby Erkson wrote:

This error is stopping my code dead in its tracks :-(

I'm programmatically creating charts when this error occurs. If I select the graph plot, right click "Format Data Series...", the error will pop up. Click OK
and then the standard "Format Data Series" window displays like normal. Is there a way to, uh, clear out the register or whatever that keeps tabs on this
setting?

Here's where the code is breaking:
...
chartAvgCalls.Axes(xlCategory).Select
Selection.TickLabels.AutoScaleFont = True
With Selection.TickLabels.Font
.Name = "Arial"
.FontStyle = "Bold" '<-- this is where the error occurs
.Size = 10
End With

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html