Cluster Stacked Chart with Difference Embedded

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

Catherine

Never mind. After drinking some caffeine, my brain started functioning.
Sorry if I created any inconvenience to anyone.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top