stacked chart from two worksheets in same workbook?

Posted on 2012-08-24
Last Modified: 2012-08-27
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.
Question by:kbdaemon

    Author Comment

    I'm back and still struggling with this - any suggestions are appreciated.  Thanks! -Kirk
    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.
    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...

    Author Closing Comment

    thanks for your help!  this works for me.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    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.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now