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 / New Users / April 2007

Tip: Looking for answers? Try searching our database.

X axis sublabels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dberrymalmberg@gmail.com - 16 Apr 2007 02:01 GMT
I'm having trouble getting two labels on the X axis. My data is such
that there is a subject's name and then two different situations for
that subject, each with a pre- and post-score. So, for each subject,
there are 4 histogram bars in 2 groups of 2.

I am trying to figure out how to have my category axis labels with the
subject's name which would go below a number 1 and a number 2. Excel
will only let me have one category value (the 1 and 2), and I cannot
figure out how to add the subject's name below those values.

Any assistance would be much appreciated! Thanks!

Sample data:

John
behavior 1
pre: 5
post: 10

John
behavior 2
pre: 6
post: 8

I'd like the X axis to read "JOHN" with a 1 under the first 2 bars and
a 2 under the second 2 bars.
Barb Reinhardt - 16 Apr 2007 02:56 GMT
For your x axis series, include both the row with the subject name and the
situation.

> I'm having trouble getting two labels on the X axis. My data is such
> that there is a subject's name and then two different situations for
[quoted text clipped - 22 lines]
> I'd like the X axis to read "JOHN" with a 1 under the first 2 bars and
> a 2 under the second 2 bars.
 
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



©2008 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.