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

Similar Threads

Clustered Stacked Chart 1
stacked chart 3
Charting 4
How do I create a combined 'cluster' and 'stacked' column chart? 1
Stacked Column Chart 3
Create a combined Cluster and Stacked Column Chart? 1
Stacked chart with 2 series 1
Stacked bar chart with totals - Excel 2003 2

Top