Cluster Stacked Chart with Difference Embedded

  • Thread starter Thread starter Catherine
  • Start date Start date
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.
 
Never mind. After drinking some caffeine, my brain started functioning.
Sorry if I created any inconvenience to anyone.
 
Back
Top