Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1225
Need some help with ColumnLine chart
posted

Fair warning : I am a novice when it comes to charting.

I am using the following data table below in a line chart currently with the exception of "Metric 4" and it works just great.  What I need to do now is include "Metric 4" as a column chart behind the current line chart.  

I have messed around with this data table in a ColumnLineChart (which appears to be what I need to use) but I can't get it to work.  Basically I need row 4 of the DataTable to be used as the datasource of the column chart.  Do I need to just make a separate data table both the column and the line chart?

-----------------------------

 DataTable dt = new DataTable();

            var columnDateString = new DataColumn("DateValue", typeof(string));
            dt.Columns.Add(columnDateString);

            dt.Columns.Add("11/1", typeof(int));
            dt.Columns.Add("11/8", typeof(int));
            dt.Columns.Add("11/15", typeof(int));
            dt.Columns.Add("11/22", typeof(int));
            dt.Columns.Add("11/29", typeof(int));
           

            dt.Rows.Add(new object[] { "% Metric 1", 0, 10 ,25,50, 80});
            dt.Rows.Add(new object[] { "% Metric 2", 0, 8, 20, 45, 70 });           
            dt.Rows.Add(new object[] { "% Metric 3", 0, 2, 5, 8 , 8 });
            dt.Rows.Add(new object[] { "Metric 4", 0, 20, 25, 25, 25 });