Writing the symbol for X bar in Excel?

[DiGiMac]

What technique do *you* use for putting single or double bars over letters in Excel ? Do you:
- use MS Equation Editor
- insert little lines over each and every occurence

From the sample sheets I've seen most people, like me, draw the lines. But positioning is fiddly and as soon as you change formatting things go wierd.
I've found Equation Editor is workable in Word but just clumsy in Excel.

Does anyone know of a ttf font that includes these characters ? That would make everything easier.

[ScottK]

I don't.

I think it's too much effort for too little gain.

I type out "x-bar". It's only 5 key strokes versus screwing around with formatting for an hour.

[Frank T.]

I use Equation Editor in excel and have never had a problem, as for a font that includes these characters don't know of any.

[SteelMaiden]

I do the same as Scott.

[Jim Wynne]

In Reply to Parent Post by DiGiMac

What technique do *you* use for putting single or double bars over letters in Excel ? Do you:
- use MS Equation Editor
- insert little lines over each and every occurence

From the sample sheets I've seen most people, like me, draw the lines. But positioning is fiddly and as soon as you change formatting things go wierd.
I've found Equation Editor is workable in Word but just clumsy in Excel.

Does anyone know of a ttf font that includes these characters ? That would make everything easier.

There are Windows fonts available for what you're looking for, such as this one. Not an endorsement, just a suggestion.

[ScottK]

In Reply to Parent Post by Jim Wynne

There are Windows fonts available for what you're looking for, such as this one. Not an endorsement, just a suggestion.

I was taking another path and looking at font editors a little while ago.

[rmf180]

If you own a TI graphing calculator, the TI Connect program which is used to add or remove items from you calculator, loads fonts (TIxx) to your system. These fonts all contain the x-bar symbol. Those fonts are free if you have the TI Connect program.

[CalRich]

In Reply to Parent Post by Frank T.

I use Equation Editor in excel and have never had a problem, as for a font that includes these characters don't know of any.

I do the same.

I once had the same dilemma to create these kind of characters in Word. For doing this in Word, however, there is a nifty way using equation fields. It essentially merges two characters together. It gets tricky when you try to do something like R bar bar (average of the average ranges).

http://www.apastyle.info/how-tos/x-bar-word-3.html