View Single Post
  #1   Report Post  
Old January 23rd 09, 03:27 PM posted to microsoft.public.excel.charting
Karen Karen is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 447
Default Grouping Data for a Chart

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