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
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
Sponsor Links





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 DiGiMac is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Mar 2008
Location: Lake Garda, North Italy
 
Posts: 1
Thanks Given to Others: 0
Thanked 1 Time in 1 Post
Karma Power: 25
Karma: 10
DiGiMac has less than 100 Karma points so far.
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 ScottK is offline
Not out of the crisis

 
Registration Date: Apr 2006
Location: Butler, NJ
 
Posts: 2,497
Thanks Given to Others: 173
Thanked 661 Times in 481 Posts
Karma Power: 292
Karma: 5329
ScottK is appreciated, and has over 1700 Karma points.
ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.
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.

__________________

Time for a new sig line.
My LinkedIn Profile
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. Frank T. is offline
Involved in Discussions

 
Registration Date: Jun 2006
Location: Illinois
Age: 38
 
Posts: 236
Thanks Given to Others: 61
Thanked 197 Times in 93 Posts
Karma Power: 57
Karma: 1312
Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.Frank T. is appreciated, and has over 1300 Karma points.
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.

__________________

"I am like any other man. All I do is supply a demand." -Al Capone
  #4  
Old 10th March 2008, 10:47 AM
SteelMaiden's Avatar
SteelMaiden SteelMaiden is offline
Super Moderator

 
Registration Date: Jan 2001
Location: NC, USA
 
Posts: 4,192
Thanks Given to Others: 575
Thanked 1,387 Times in 847 Posts
Karma Power: 495
Karma: 11454
SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.
SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.SteelMaiden is appreciated, and has over 1700 Karma points.
Re: Writing the symbol for X bar in Excel?

I do the same as Scott.

__________________

"It's fun to have fun, but you have to know how", Dr. Seuss
Man may have invented fire, it took a woman to learn how to play with it.
  #5  
Old 10th March 2008, 01:16 PM
Jim Wynne's Avatar
Jim Wynne Jim Wynne is offline
Cross Forum Moderator

 
Registration Date: Jan 2005
Location: Southeast Wisconsin
 
Posts: 13,894
Thanks Given to Others: 1,989
Thanked 5,848 Times in 3,735 Posts
Blog Entries: 2
Karma Power: 1510
Karma: 41702
Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.
Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.
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.

__________________

It is difficult to get a man to understand something, when his salary depends upon his not understanding it. --Upton Sinclair
  #6  
Old 10th March 2008, 01:21 PM
ScottK's Avatar
ScottK ScottK is offline
Not out of the crisis

 
Registration Date: Apr 2006
Location: Butler, NJ
 
Posts: 2,497
Thanks Given to Others: 173
Thanked 661 Times in 481 Posts
Karma Power: 292
Karma: 5329
ScottK is appreciated, and has over 1700 Karma points.
ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.ScottK is appreciated, and has over 1700 Karma points.
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.

__________________

Time for a new sig line.
My LinkedIn Profile
  #7  
Old 14th March 2008, 08:47 AM
rmf180's Avatar
rmf180 rmf180 is offline
Involved in Discussions

 
Registration Date: Apr 2006
Location: Ohio
Age: 47
 
Posts: 41
Thanks Given to Others: 32
Thanked 22 Times in 15 Posts
Karma Power: 37
Karma: 371
rmf180 is appreciated, and has over 300 Karma points.rmf180 is appreciated, and has over 300 Karma points.rmf180 is appreciated, and has over 300 Karma points.rmf180 is appreciated, and has over 300 Karma points.
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 CalRich is offline
Appreciated Member

 
Registration Date: Jun 2005
Location: Charlotte, NC
 
Posts: 124
Thanks Given to Others: 31
Thanked 41 Times in 25 Posts
Karma Power: 48
Karma: 261
CalRich is appreciated, and has over 200 Karma points.CalRich is appreciated, and has over 200 Karma points.CalRich is appreciated, and has over 200 Karma points.
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 03:01 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