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. HELP! |
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! |
All times are GMT +1. The time now is 05:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com