Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
y-AXIS
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
y-AXIS
On Fri, 14 Sep 2007, in microsoft.public.excel.charting,
Sam said: 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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |