View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Catherine Catherine is offline
external usenet poster
 
Posts: 67
Default 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