Creating G A Vowel Chart In E Excel:

ADVERTISEMENT

de Jo
ong / Rankine
en 
           
                       
 L541‐Creatin
ng a Vowel Ch
hart in Excel  
                       
                       
   Spring 2011
Creating
g a Vowel
Chart in E
Excel:
1) Downl
oad XY Char
rt Labeler:
htt
tp://
tilities/ChartL
Labeler.htm
-
Only for Win
ndows version
n (Mac may n
not be able to
o download f
file)
2) Re-ope
en Excel (the
XY Chart La
abeler will no
ot show up on
n your tool ba
ar until you r
re-open Excel
l).
3) Data H
Handling:
First, you
need to label
the columns
Word,
, Vowel, T1-Ti
ime, T1-Forma
ant 1, T1-Form
mant 2, T2-Tim
me, T2-Forman
nt 1, T2-Forma
ant 2\
4) Creat
e Scatterplot
:
Press the <
<Insert> tab
b  <Scatte
er>  you’ll
l want the sca
atter w/ mark
ks only (a scat
tterplot type)
This will p
pull up a basi
ic scatterplot.
5) Right
t-click the sca
atterplot and s
select <Selec
ct Data>
6) Here
is how you’ll
l want to set-
up your data
points in Sel
lect Data box
x:
Select the
entry in the L
Legend Entrie
es and select
<Edit>
Edit Series
s:
Series
name:
‘T
Temp Point 1’
’ (or whatever
r you want to
o call your fir
rst temporal p
point data)
Series
x values: Th
hese are your
r T1-Formant
t 2 values <s
select all vow
wels of that co
olumn>
Series
y values: T
hese are your
r T1-Formant
t 1 values <s
select all vow
wels of that co
olumn>
Press
<OK>
Press <Ad
dd> in the S
Select Data So
ource box
Edit Series
s:
Series
name:
‘T
Temp Point 2’
’ (or whatever
r you want to
o call your fir
rst temporal p
point data)
Series
x values: Th
hese are your
r T2-Formant
t 2 values <s
select all vow
wels of that co
olumn>
Series
y values: T
hese are your
r T2-Formant
t 1 values <s
select all vow
wels of that co
olumn>
If you 
have any que
estions, pleas
se contact me
e at wrankine
e@indiana.ed
du. 
 

ADVERTISEMENT

00 votes

Related Articles

Related forms

Related Categories

Parent category: Education
Go
Page of 2