• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

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
0
kbdaemon
Asked:
kbdaemon
  • 2
  • 2
1 Solution
 
kbdaemonAuthor Commented:
I'm back and still struggling with this - any suggestions are appreciated.  Thanks! -Kirk
0
 
SteveCommented:
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
 
SteveCommented:
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
 
kbdaemonAuthor Commented:
thanks for your help!  this works for me.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now