Stacked columns

Question

I am trying to create a chart showing current budget and proposed budget for each month where the budget is comprised of 3 elements. I would like to display two separate stacked cloumns for each month . I would like to have the same colors for 2 of the eleemnts but a different color for 1 of the elemets. See crude drawing below. Separate colors for o and n same colors for a,b and c ,d although different values for each month.

Is ths possible?

Crude drawing:

      a b    a b    a b    a b    a b    a b    a b    a b    a b    a b    a b    a b
        a b    a b    a b    a b    a b    a b    a b    a b    a b    a b    a b    a b
        a b    a b    a b    a b    a b    a b    a b    a b    a b    a b    a b    a b
        c b    c d    c d    c d    c d    c d    c d    c d    c d    c d    c d    c d   
        c b   c d    c d    c d    c d    c d    c d     o d    c d    c d    c d    c d   
        c d    c d    c d    c d    c d    c d    c d    o d    c d    c d    c d    c d   
        o d    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n
        o n    o n    o n    o n    o n    o n   o n   o n    o n    o n    o n    o n

        Jan   Feb    Mar   Apr    May   Jun   Jul    Aug   Sep   Oct    Nov   Dec

Answer 1

As far as I understand you have 6 series of data for each month: 3 series for the current budget + 3 series for the proposed budget. 

You want also each budget series to be visualized as 100% stacked columns.

- Create 6 series of StackedColumn100 type.

- On the first 3  series ( current budget ) set in custom properties StackedGroupName=current

- On the next 3 series ( proposed budget ) set in custom properties StackedGroupName=proposed

<asp:Chart ID="Chart1" runat="server" >
            <Series>
                <asp:Series ChartArea="ChartArea1" ChartType="StackedColumn100" Color="Red" CustomProperties="StackedGroupName=current"
                    Name="SeriesO">
                </asp:Series>
                <asp:Series ChartArea="ChartArea1" ChartType="StackedColumn100" Color="Gray" CustomProperties="StackedGroupName=current" 
                    Name="SeriesC">
                </asp:Series>
                <asp:Series ChartArea="ChartArea1" ChartType="StackedColumn100" Color="Gray" CustomProperties="StackedGroupName=current" 
                    Name="SeriesA">
                </asp:Series>
                <asp:Series ChartArea="ChartArea1" ChartType="StackedColumn100" Color="Blue" CustomProperties="StackedGroupName=proposed" 
                    Name="SeriesN">
                </asp:Series>
                <asp:Series ChartArea="ChartArea1" ChartType="StackedColumn100" Color="Gray" CustomProperties="StackedGroupName=proposed" 
                    Name="SeriesD">
                </asp:Series>
                <asp:Series ChartArea="ChartArea1" ChartType="StackedColumn100" Color="Gray" CustomProperties="StackedGroupName=proposed" 
                    Name="SeriesB">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>

Bind your data.

You can set color for each series at your discretion.

Regards,

Delian

 

Answer 2

Thanks Delian I did not know about the custom properties.  I appreciate the help.

Answer 3

Just what I was looking for.

Thanks!!

rg,
Eric