ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Grouping Data for a Chart (https://www.excelbanter.com/charts-charting-excel/217654-grouping-data-chart.html)

Karen January 23rd 09 04:27 PM

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!

John Mansfield January 24th 09 03:00 PM

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 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com