Superscript in chart's x-axis

[Fred Smith]

I would like to category labels with a superscript in them. Is this
possible?

Even though my data is formatted correctly, and the superscript shows, the
superscript is ignored when the chart is displayed. The chart is produced by
a macro, so I'd be happy to use VBA if that would provide a solution.

 

[Debra Dalgleish]

The following post by Jon Peltier has some code to create a dummy axis
and labels:


http://groups.google.com/groups?&threadm=1441c01c13189$c684d840$a4e62ecf@tkmsftngxa06

and there's more information on his web site:

http://www.peltiertech.com/Excel/Charts/ArbitraryAxis.html

You can download Rob Bovey's Chart Labeler (a free add-in) here:

http://www.appspro.com/utilities/Labeler.asp