Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 134
Default X-Bar in Statistical Process Control

Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default X-Bar in Statistical Process Control

Some notes from previous messages on this topic:

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilŕ.

from Michael Bednarek

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.


best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob Barnes" wrote in message
...
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 134
Default X-Bar in Statistical Process Control

Bernard - Thank you - Bob

"Bernard Liengme" wrote:

Some notes from previous messages on this topic:

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilĂ*.

from Michael Bednarek

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.


best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob Barnes" wrote in message
...
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 837
Default X-Bar in Statistical Process Control

There are also fonts that have x-bar in their basic (non-unicode) character
set. Two such fonts are

xbar is Alt-0214 in the Math Ext font from
http://www.columbia.edu/~em36/wpdos/wptoword.html

xbar is Alt-0120 in the MS Reference 1 font

Jerry

"Bernard Liengme" wrote:

Some notes from previous messages on this topic:

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilĂ*.

from Michael Bednarek

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.


best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bob Barnes" wrote in message
...
Is the mean/ average.

Is there a way to enter a Capital X which a "underscore" over it to get a
"X-Bar"??

TIA - Bob




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistical Process Control chart Tang Leep Boon Charts and Charting in Excel 1 June 13th 06 09:48 AM
statistical process control Donbenn Charts and Charting in Excel 2 February 15th 06 01:00 PM
If/then Process? Zane B Stein Excel Discussion (Misc queries) 1 December 20th 05 03:27 PM
Speed up the process Ali Baba Charts and Charting in Excel 2 October 3rd 05 06:40 PM
Control Tab from Combo box- format control missing!! Mo Excel Discussion (Misc queries) 3 January 7th 05 01:09 PM


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"