Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP.NET SQL Chart
I have a sql table which includes
process ID, paymentType, processDby, indexedExitDate, processExitedate..
I need to create 1 chart with all the proceess that has occured for last 10 days where the payment type = "Advance" & "GRN" (which i did). Also in to that paticular chart i need to add a line graph, that should include the total average of processes done by 5 persons "a,b,c,d,e"(under processed by column) & payment type="Advance". So in the X coulumn it displays last 10 days. In Y column it diplays all processed items per that day (Count(processID)). So how can I get the 2nd line graph in the same chart using same data source?
Posted 5-Sep-12 20:12pm
Edited 6-Sep-12 1:22am
deepakaitr12345 at 6-Sep-12 4:12am
You can add the another series with the chart type (line)just like below
var Test = new Series("Test");Test.ChartType = SeriesChartType.Line;
Test.YAxisType = AxisType.Primary;chart.Series.Add(Test);
chart.Series[0].Color = Color.CornflowerBlue;var Test1 = new Series("Test1");
Test1.ChartType = SeriesChartType.Column;Test1.YAxisType = AxisType.Primary;
chart.Series.Add(Test1);chart.Series[1].Color = Color.YellowGreen;
var Test11 = new Series("Test11");Test11.ChartType = SeriesChartType.Line;
Test11.YAxisType = AxisType.Secondary;chart.Series.Add(Test11);
chart.Series[2].Color = Color.Purple;Hope it will help youThanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Schatak 400
1 OriginalGriff 355
2 Sergey Alexandrovich Kryukov 144
3 _Amy 115
4 Rob Philpott 100
0 OriginalGriff 7,097
1 Sergey Alexandrovich Kryukov 5,623
2 Maciej Los 3,504
3 Peter Leow 3,373
4 DamithSL 2,505

Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 6 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100