Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gantt Chart - Grouping? | Charts and Charting in Excel | |||
Pivot Chart Grouping | Charts and Charting in Excel | |||
Pivot Chart Grouping | Excel Discussion (Misc queries) | |||
Grouping before entering into a chart | Charts and Charting in Excel | |||
Grouping of chart. | Charts and Charting in Excel |