by groups bar

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

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

In article <a0f79d02.0311251336.2d330460@posting.google.com>,
giusva@hotmail.com says...
> 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
>