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 / September 2007

Tip: Looking for answers? Try searching our database.

y-AXIS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sam - 14 Sep 2007 13:54 GMT
Hi,
I'm working on a neuroscience project and I data that looks like this:
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
.......keeps going until
105

Basically, this data is in tha A column and it goes up to about 2217. The
numbers represent age at death.
I want to make a bar graph with the x-axis as "age at death" and the y-axis
as "number of those that died".
I'm sure there's an easy way of doing this as I only have one column of
data, but each time I try to make a graph, it does something that looks like
a cumulative graph.

HELP!!!!

Samantha Perera
Del Cotter - 14 Sep 2007 18:01 GMT
>The numbers represent age at death. I want to make a bar graph with the
>x-axis as "age at death" and the y-axis as "number of those that died".

Make a Pivot Table or Pivot Chart, using the single column. Be sure to
give it a name, like "Data", at the very top of the column

Data
0
0
1
1

Then have your table be "Count of Data" against "Data", and you will
have the distribution you seek.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

 
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.