by groups bar

[Giusva]

Hi all,

I am trying to graph the following data (example)

12.1 1
13.1 1
14.1 1
12.1 1
15.2 2
16.3 2
18.2 2
11.2 2
13.3 2
and so on...

where the first column represents (means) variables for group
1,2,3,...
I would like to have a grouped bar graph (5 bars for group 1, space, 5
bars for group 2 and so on) . Is there a way to do this with excel?

thanks

 

[Tushar Mehta]

The easiest and quickest way would be to reorganize the data as in:

Means
1 12.1
1 13.1
1 14.1
1 12.1

2 15.2
2 16.3
2 18.2
2 11.2
2 13.3

3 12.1
3 13.1
3 16.3
3 18.2
3 11.2

Once done, on the chart, double-click the plotted column. In the
resulting dialog box, from the Options tab, set the Gap Width to zero.

And, no, you don't have to reorganize your original dataset. Use a
copy.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions