How can I graph the following: 100 deaths in 2005 (80cats/20dogs).

M

Maly

How can a I graph the following: 100 patients cleared for surgery in wk 1,
200 patients cleared in wk 2. That part is easy, now I want to break down
each column so that it shows that a 30/70 split (30 minors/70 adults)
 
J

John Wilson

First column of data sheet would be

week 1
30
70

Then choose chart type - stacked column
--
 
M

Maly

Ok - I explained that wrong, let me try again.
Week 1 = 100 patients cleared for surgery, 30 minor/70 adults. This I know I
can put in one column. Now, I need to add to week 1 another column, where 200
patients were NOT cleared for surgery, 50 minors/150 adults. Can this be
done? What I would like to see is: two columns under week one (cleared and
not cleared) each column divided in 2 (minors/adults).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Triangulation chart 7
Excel 2002, problem with Text to Columns 0
Text to Columns problem 0
Complicated IF statement - desperately need some help 4
Extracting data from spreadsheet to a graph 1
Graph usage for times of day 0
Shading areas in a graph 3
Occasional meter readings chart 0

Top