Click here to Skip to main content
12,406,342 members (70,579 online)
Rate this:
 
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
Updated 6-Sep-12 1:22am
v3
Comments
deepakaitr12345 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160730.1 | Last Updated 6 Sep 2012
Copyright © CodeProject, 1999-2016
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