The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Miner's MSA (Measurement Systems Analysis) Blog   Elsmar.com Forum Home Page
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username

Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Donate and $ Contributor Forum Access

Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 10th March 2008, 07:28 AM
DiGiMac

 
 
Posts: 1
Please Help! Writing the symbol for X bar in Excel?

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.

Sponsored Links
  #2  
Old 10th March 2008, 08:15 AM
ScottK's Avatar
ScottK

 
 
Posts: 2,525
Re: Writing X bar in Excel ?

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.
Thanks to ScottK for your informative Post and/or Attachment!
Sponsored Links

  #3  
Old 10th March 2008, 08:57 AM
Frank T.'s Avatar
Frank T.

 
 
Posts: 236
Re: Writing X bar in Excel ?

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.
  #4  
Old 10th March 2008, 10:47 AM
SteelMaiden's Avatar
SteelMaiden

 
 
Posts: 4,192
Re: Writing the symbol for X bar in Excel?

I do the same as Scott.
  #5  
Old 10th March 2008, 01:16 PM
Jim Wynne's Avatar
Jim Wynne

 
 
Posts: 14,077
Re: Writing the symbol for X bar in Excel?

Quote:
In Reply to Parent Post by DiGiMac View Post

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.
  #6  
Old 10th March 2008, 01:21 PM
ScottK's Avatar
ScottK

 
 
Posts: 2,525
Re: Writing the symbol for X bar in Excel?

Quote:
In Reply to Parent Post by Jim Wynne View Post

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.
  #7  
Old 14th March 2008, 08:47 AM
rmf180's Avatar
rmf180

 
 
Posts: 43
Re: Writing the symbol for X bar in Excel?

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.
  #8  
Old 14th March 2008, 12:44 PM
CalRich's Avatar
CalRich

 
 
Posts: 124
Re: Writing X bar in Excel ?

Quote:
In Reply to Parent Post by Frank T. View Post

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
Thanks to CalRich for your informative Post and/or Attachment!
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Writing the symbol for R bar bar (double bar) in Excel kedarg6500 Excel .xls Spreadsheet Templates and Tools 3 4th December 2009 09:51 PM
60601 Symbol Issue - CE Mark Symbol and Size Requirements DuttonT IEC 60601 - Medical Electrical Equipment Safety Standards Series 1 25th April 2008 01:19 PM
X bar s chart template / form for Excel .xls randymhl Excel .xls Spreadsheet Templates and Tools 2 14th March 2006 10:19 PM
How to add a vertical reference line in my excel .xls bar graph Indul Excel .xls Spreadsheet Templates and Tools 9 30th July 2005 01:12 PM
Seeking: X bar R chart software - Or how to do one in Excel kapoor Statistical Analysis Tools, Techniques and SPC 6 28th March 2005 01:38 PM



The time now is 08:13 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272
NOTE: This forum uses "cookies".