I had to struggle with this a bit so I'm gonna share what I figured out.
To make a stacked column chart from a SqlDataSource you need to use DataBindCrossTable like this...
CHART1.DataBindCrossTable(SqlDataSource1.Select(DataSourceSelectArguments.Empty), "proceso_estado_nombre", "max_fecha_final", "valor", "")
Now, each series created needs to be converted to StackedColumn type, which you do like this...
For Each series As DataVisualization.Charting.Series In CHART1.Series series.ChartType = DataVisualization.Charting.SeriesChartType.StackedColumnNext
The problem at this point is that the chart wont work if you don't have the same number of points in each series and each set of points should have the same X values. So to fill in the empty points in each series you can use InsertEmptyPoints like this...
CHART1.DataManipulator.InsertEmptyPoints(1, DataVisualization.Charting.IntervalType.Months, series.Name.ToString)
However, when I did this I got inconsistent results. See below...
<Series> <Series Name="Terminado" Legend="Default" XValueType="Date" ChartType="StackedColumn" ChartArea="ChartArea1" ToolTip="Terminado: #VALY{C0}"> <Points>

**View Complete Post**

## How do I create a stacked column chart over yrly/mo series/category?

hello,

I would like my output to look like this:

2009 2010

|__c___|

|__c__| | __b__|

|__b _| | a |

| a | | _____|

January

where both of the stacked bars represent data for the month of January such that each month would have it's own two years worth of stacked bar data...please help.