Prev: Ran into the same issue
Next: Loss of referenced data (Titles) when upgrading from Excel 2000 to2007
From: Catherine on 18 Feb 2010 14:50
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
From: Catherine on 18 Feb 2010 16:29
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
 | 
Pages: 1
Prev: Ran into the same issue
Next: Loss of referenced data (Titles) when upgrading from Excel 2000 to2007