pi symbol as a chart label

[Tyrone Patterson]

Colleagues,

Am i able to insert the Pi symbol in to an excel worksheet
and use it in a chart Xaxis labels eg: pi/2,pi,3pi/2,2pi.

If so what are the keystrokes please.

thank you

tyrone patterson

 

[Richard J.]

pi can be displayed by typing lower-case "p" in Symbol font.

 

[Jon Peltier]

Tyrone -

Richard suggests using the Symbol font for your labels. Unfortunately
this mandates the use of a Line chart, where you might rather have an XY
Scatter chart. If so, chart the data using actual angular values in
radians, then make a dummy axis following this procedure:

http://www.geocities.com/jonpeltier/Excel/Charts/ArbitraryAxis.html

(put your dummy axis along the X axis, of course). Format the range
containing your dummy axis labels using Symbol font, prior to using
Rob's Chart Labeler; the Labeler add-in has a great feature of copying
the cell format to the labels.

- Jon