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.