The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
UL - Underwriters Laboratories - Health Sciences
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > 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

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

Writing the symbol for X bar in Excel?


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links



Courtesy Quick Links

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


ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Atul's
Quality Forum Online

Howard's
International Quality Services

Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum

Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Related LinkedIn Groups

ISO 9001 for Small Businesses

ISO 9001:2015 Revision Discussions

Information Security Community

Medical Devices Group

Quality and Regulatory Network

FDA (Food and Drugs)

AS91XX Series - Tips and Advice


Related Topic Tags
microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  Post Number #1  
Old 10th March 2008, 07:28 AM
DiGiMac

 
 
Total 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
  Post Number #2  
Old 10th March 2008, 08:15 AM
ScottK's Avatar
ScottK

 
 
Total Posts: 2,584
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

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

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

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

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

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

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

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

 
 
Total 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 Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

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
Use of the EN 980 Manufacturer Symbol leroybrown CE Marking (Conformité Européene) / CB Scheme 3 3rd March 2011 03:49 PM
Export some dates from an excel spreadsheet - EXCEL Question RollingStones Excel .xls Spreadsheet Templates and Tools 3 9th August 2010 12:41 PM
Writing the symbol for R bar bar (double bar) in Excel kedarg6500 Excel .xls Spreadsheet Templates and Tools 3 4th December 2009 10: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
Need excel formating help - Have excel automatically populate a column mike101338 Excel .xls Spreadsheet Templates and Tools 19 7th September 2005 03:30 PM



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


 


NOTE: This forum uses "Cookies" -- The Elsmar Cove is *Copyright Free*.
A Peachfarm LLC Internet Property