Cluster Stacked Chart with Difference Embedded
I'm using Excel 2003. I know how to create a cluster stacked chart, but now I
want to add a difference. A example of my data is below. JAN FEB Screen Enroll Screen Enroll Site 1 5 2 7 3 Site 2 6 1 9 4 I want to stack for each site Screen and Enroll with the total being equal to Screen. So for instance, I want to have the JAN stack for Site 1 to be equal to 5 with 2 embedded within 5. I could set up my table to be: Screen = Screen - Enroll. But I want to know if there is a cleaner way to create this chart. Thanks in advance. -- Catherine |
Cluster Stacked Chart with Difference Embedded
Never mind. After drinking some caffeine, my brain started functioning.
Sorry if I created any inconvenience to anyone. -- Catherine "Catherine" wrote: I'm using Excel 2003. I know how to create a cluster stacked chart, but now I want to add a difference. A example of my data is below. JAN FEB Screen Enroll Screen Enroll Site 1 5 2 7 3 Site 2 6 1 9 4 I want to stack for each site Screen and Enroll with the total being equal to Screen. So for instance, I want to have the JAN stack for Site 1 to be equal to 5 with 2 embedded within 5. I could set up my table to be: Screen = Screen - Enroll. But I want to know if there is a cleaner way to create this chart. Thanks in advance. -- Catherine |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com