Excel 2007 Clustered Column Help

[MattGreer]

I have data from an experiment that I have grouped together. It looks something like this:

Group Revolutions  Height
1      6             4
1      9             2
2      6             7
2      9             3
2      9             2
3      6             15
3      9             6
4      6             9
4      6             33
4      9             7
4      9             33

I want to create a clustered column chart that shows the bars grouped on the horizontal axis first by Group, and then by "Time", and then by "Height", such that we can see the variation in Height compared with Time for each Group. Each Group represents similar experiment parameters, so that the parameters of Group 1 are not comperable to Group 3.

How can this be accomplished without having to completely reformat my data set and without gaps between the bars in the clustered column chart?

Hope this makes sense. Thanks for your help!!

Thanks!!


Matt

 

[AnotherHiggins]

Have a look at a pivot chart

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[MattGreer]

OK, I can get the Group to show up on the x-axis, but how do I get the individual values of Height to show up for the corresponding number of Revolutions?

Thanks!!


Matt