View Single Post
  #2   Report Post  
Old January 24th 09, 02:00 PM posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 235
Default Grouping Data for a Chart

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

--
John Mansfield
cellmatrix.net


"Karen" wrote:

"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!