Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

by groups bar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Giusva - 25 Nov 2003 21:36 GMT
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 - 26 Nov 2003 14:09 GMT
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.

Signature

Regards,

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

> Hi all,
>
[quoted text clipped - 17 lines]
>
> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.