asked on

stacked chart from two worksheets in same workbook?

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

kbdaemon

ASKER

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

Steve

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

ASKER CERTIFIED SOLUTION

Steve

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kbdaemon

ASKER

thanks for your help! this works for me.