On Wed, 7 Nov 2007, in microsoft.public.excel.charting,
Al said:
Will that show, on the x-axis the value "pi/2" (with the Greek letter) or
1.5708?
Only the numbers. If you want special text, you need to create a
completely artificial X-axis labelling series, by typing the following
cells:
X-labels
1.570796327 0 p/2
3.141592654 0 p
4.712388980 0 3p/2
6.283185307 0 2p
Where the font in the third column is formatted in the "Symbol" font, as
B.R. says. Now select the first two columns and Paste Special them to
the chart as a scatter series (I assume the chart is a scatter chart),
then use one of the labelling add-ins:
Rob Bovey's Chart Labeler
http://www.appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools
http://j-walk.com/ss/excel/files/charttools.htm
to give that series a set of data labels based on the third column. Then
format the series to be invisible so only the labels show.
Alternatively, for just a few labels, you can put them in manually,
without installing either the of the add-ins (but they can be very
useful if you're doing a lot of advanced Excel charting)
For more tips on making custom axis labels (one of the tougher custom
Excel techniques, but one of the most powerful), check out the tutorials
by Jon Peltier
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
and Tushar Mehta
http://www.tushar-mehta.com/excel/ne...ble_log_scale/
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.