Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike D
 
Posts: n/a
Default the Statistical symbol "Xbar"

Does anyone know have to get or make an "Xbar" symbol for Excel? I can't seem
to find one in the symbols available

thanks,
mike duclos
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default the Statistical symbol "Xbar"

Mike,

Take a look at this post...
http://makeashorterlink.com/?A2D012F6C

Jim Cone
San Francisco, USA
Free add-ins...
http://www.realezsites.com/bus/primitivesoftware



"Mike D"
wrote in message

Does anyone know have to get or make an "Xbar" symbol for Excel?
I can't seem to find one in the symbols available
thanks,
mike duclos
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis
 
Posts: n/a
Default the Statistical symbol "Xbar"

http://groups.google.com/group/micro...aad00398e465f5

Jerry

"Mike D" wrote:

Does anyone know have to get or make an "Xbar" symbol for Excel? I can't seem
to find one in the symbols available

thanks,
mike duclos

  #4   Report Post  
Posted to microsoft.public.excel.misc
Jack Sons
 
Posts: n/a
Default the Statistical symbol "Xbar"

Jim,

Equation Editor? Isn't that something from Word? To overbar characters in
Word I use the macro below. I have no idea where to find an overbar
possibility in Excel. Please let me know where I can find it, if there is
any.

Jack Sons
The Netherlands

Sub Overline()
Dim sChar As String
Dim i As Integer
sChar = InputBox("Enter characters to overline", "Overline")
With Selection
For i = 1 To Len(sChar)
..Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
PreserveFormatting:=False
..Delete Unit:=wdCharacter, Count:=1
..TypeText Text:="EQ \s\up6(\f(;" + Mid(sChar, i, 1) + "))"
..Fields.Update
..MoveRight Unit:=wdCharacter, Count:=1
Next
End With
End Sub



"Jim Cone" schreef in bericht
...
Mike,

Take a look at this post...
http://makeashorterlink.com/?A2D012F6C

Jim Cone
San Francisco, USA
Free add-ins...
http://www.realezsites.com/bus/primitivesoftware



"Mike D"
wrote in message

Does anyone know have to get or make an "Xbar" symbol for Excel?
I can't seem to find one in the symbols available
thanks,
mike duclos



  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default the Statistical symbol "Xbar"

Jack Sons,

I believe Equation Editor is part of the Office Suite.
The file name is: EQNEDT32.EXE

Jim Cone
San Francisco, USA


"Jack Sons" wrote in message

Jim,
Equation Editor? Isn't that something from Word? To overbar characters in
Word I use the macro below. I have no idea where to find an overbar
possibility in Excel. Please let me know where I can find it, if there is
any.
Jack Sons
The Netherlands

Sub Overline()
Dim sChar As String
Dim i As Integer
sChar = InputBox("Enter characters to overline", "Overline")
With Selection
For i = 1 To Len(sChar)
..Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
PreserveFormatting:=False
..Delete Unit:=wdCharacter, Count:=1
..TypeText Text:="EQ \s\up6(\f(;" + Mid(sChar, i, 1) + "))"
..Fields.Update
..MoveRight Unit:=wdCharacter, Count:=1
Next
End With
End Sub



"Jim Cone" schreef in bericht
...
Mike,

Take a look at this post...
http://makeashorterlink.com/?A2D012F6C

Jim Cone
San Francisco, USA
Free add-ins...
http://www.realezsites.com/bus/primitivesoftware



"Mike D"
wrote in message

Does anyone know have to get or make an "Xbar" symbol for Excel?
I can't seem to find one in the symbols available
thanks,
mike duclos





  #6   Report Post  
Posted to microsoft.public.excel.misc
Jack Sons
 
Posts: n/a
Default the Statistical symbol "Xbar"

Jim,

Thanks, it was indeed on my Office 2k CD.

Jack.
"Jim Cone" schreef in bericht
...
Jack Sons,

I believe Equation Editor is part of the Office Suite.
The file name is: EQNEDT32.EXE

Jim Cone
San Francisco, USA


"Jack Sons" wrote in message

Jim,
Equation Editor? Isn't that something from Word? To overbar characters in
Word I use the macro below. I have no idea where to find an overbar
possibility in Excel. Please let me know where I can find it, if there is
any.
Jack Sons
The Netherlands

Sub Overline()
Dim sChar As String
Dim i As Integer
sChar = InputBox("Enter characters to overline", "Overline")
With Selection
For i = 1 To Len(sChar)
.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _
PreserveFormatting:=False
.Delete Unit:=wdCharacter, Count:=1
.TypeText Text:="EQ \s\up6(\f(;" + Mid(sChar, i, 1) + "))"
.Fields.Update
.MoveRight Unit:=wdCharacter, Count:=1
Next
End With
End Sub



"Jim Cone" schreef in bericht
...
Mike,

Take a look at this post...
http://makeashorterlink.com/?A2D012F6C

Jim Cone
San Francisco, USA
Free add-ins...
http://www.realezsites.com/bus/primitivesoftware



"Mike D"
wrote in message

Does anyone know have to get or make an "Xbar" symbol for Excel?
I can't seem to find one in the symbols available
thanks,
mike duclos





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
€ (euro) symbol in Excel charts bananabob Charts and Charting in Excel 1 September 20th 05 01:30 PM
The Mathematical "Implies" symbol Gary T Excel Discussion (Misc queries) 3 July 26th 05 01:03 PM
how to find and replace a symbol in my worksheet TC Excel Discussion (Misc queries) 3 May 3rd 05 06:29 PM
I need a symbol but "symbol" in the Insert menu is grayed-out. Nothappy Excel Discussion (Misc queries) 2 May 3rd 05 12:16 AM
Historical Excel question statistical capabilities [email protected] Excel Discussion (Misc queries) 1 April 22nd 05 04:29 PM


All times are GMT +1. The time now is 09:36 PM.

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

About Us

"It's about Microsoft Excel"