Grouping Data for a Chart

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

"I have the following raw data and I want to create a chart.
Age Type I Type II Type III
16 20.2 24.5 23.5
17 19.8 23.6 19.8
18 17.6 24.8 18.7
19 23.5 25.3 18.2

I'm not sure how to group this so "Age" is on my X-Axis and "Type" are the
individual groups for each age.
I transposed the data and that doesn't work either.
HELP!
 
A setup like this will put Age and Type on the X axis with Data as your first
series. Be sure there are blank cells between the ages as shown below.

Age Type Data
16 I 20.2
II 24.5
III 23.5
17 I 19.8
II 23.6
III 19.8
18 I 17.6
II 24.8
III 18.7
19 I 23.5
II 25.3
III 18.2
 
Back
Top