Solved

# stacked chart from two worksheets in same workbook?

Posted on 2012-08-24
246 Views
I have two worksheets in an excel workbook and I would like to view the data on one chart.  I do not know how to create a stacked column chart using data ranges from two worksheets - E2:P55 on "Active Issued 2002-2012" and A1:L54 on "Terminations 2002-2012".  If I could stack them it would let me see the total number of policies (the worksheets contain policy counts) issued within a year broken down into active and terminated.
Thanks for your help!  I've got to head to a meeting and won't get out until 2PM central time so please forgive my lack of responding until that time.
Thanks,
Kirk
20120802-Summary-LIFE-Policies-2.xlsx
0
Question by:kbdaemon

Author Comment

I'm back and still struggling with this - any suggestions are appreciated.  Thanks! -Kirk
0

LVL 24

Expert Comment

OK, to get two (or more) ranges from seperate sheets:

Create the graph of one sheet (the most columns one).
Then you will have to add new columns one at a time to the chart.
This is Right click > select Data > add.

I think you want to have two stacked lines next to eachother, but this I cannot do.
So I have summed up both sheets in a total line which can then be charted.
See attached.
20120802-Summary-LIFE-Policies-2.xlsx
0

LVL 24

Accepted Solution

I am not sure if this is what you wanted overall, but after reading your original post it may be.
See attached...
20120802-Summary-LIFE-Policies-2.xlsx
0

Author Closing Comment

thanks for your help!  this works for me.
0

## Featured Post

### Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.