If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|