C
Catherine
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.
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.