Web Forms :: Use SQLDataSource As Datasource In Line Chart?
Mar 10, 2011
It is easy to use SQLDataSource as data data source in Column chart (see code below). Is there any easy way to use SQLDATASource to fill line chart with minimum configuration? Most samples I found on the web do not use SQLDATASOURCE as data source .
I've been wrestling with this for a while. What I want to do SEEMS like it would be very simple, buy nothing about it so far has been. Any assistance would be absolutely outstanding.Basic concept of what I want to do is...
i have column chart on my page i want to disaply line at zero and all other grid lines visible false how i can i do that i am using asp.net 4.0 chart control
I have to create a line chart from a sql query. It is as follows:
[Code]....
However,I need to take PlayerName into account too.For example,if there are 2 different PlayerNames,2 different series will be shown on the line chart.
I don't want to display the grid inside the line chart. Also I want to show a multiple lines in a single line chart(single chart displaying multiple line charts).
I need to create a chart, preferably using MS Chart Controls, that looks like a stepline chart with the exception that color has to be filled in under the line. An area chart won't block off values like a stepline chart (it creates a direct, or curved, line from one point to another). An area chart does fill in the color the way I would like it to be but I want a stepline effect. What I guess I want is a StepArea chart. I would imagine that it should be possible but I haven't been able to configure it the way I want. how I can do this?
I am working with chart controls in VS 2010. I have used sqldatasource. I want to populate select values from sqldatasource and display it on the chart controls.According to the chart samples: http://code.msdn.microsoft.com/mschart/Release/ProjectReleases.aspx?ReleaseId=4418the chart controls are databound in the page_load event. Then in which page event should I select data from sqldatasource?Code for sqldatasource selection
I have a graph created with MS Chart like the following picture. As you can see the vertical lines are messed up with value of the top of each bar. Here's the mark-up for the graph:
In the "LineChart", everytime last "y-axis" point is going out of graph (i.e., somewhere in the footer of x-axis)
X-axis Y-axis
3.4 5.2
5.3 7
2 8.7
1) like in above table, all the point will plot except the last x-axis and y-axis points. Also, y-axis value = 8.7 goes away from graph and comes in the footer of x-axis line.
2) like if x-axis = 3, y-axis=6, then 6 goes out of the graph and comes in footer of x-axis line.
But this problem occurs only when Im using SELECT query for a "particular Id" i.e.,
SELECT x,y from Table1 where Id='Gaug9' and DeletionDate is null
If I will remove where Id=' ' then it will work fine. But I need to plot graph based on particular Id's.
I followed the article found in below link. When i run the page, only one line gets generated according to the values retireved last. URL....
C# string query = string.Format("SELECT CHAR(CDATE, ISO),CSCUNITPRICE FROM UNITZ.DAILYLOG where fundcode = 'BAL'"); DataTable dt = GetData(query); string[] x = new string[dt.Rows.Count]; decimal[] y = new decimal[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++)
On my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.
How can I change the graph so that it shows 12 months before it does the auto labels?
Here is the server control code I am currently using.
<asp:Chart ID="ChartAlertes" runat="server" Width="500px"> <Titles> <asp:Title Text="Nombre d'alertes et leurs status en fonction des filtres renseignés" BorderColor="Black" Alignment="TopCenter"> </asp:Title> </Titles>
[code]...
I display 2 Points (2 columns) in the Chart Control and I change the color of the each Points with :
But sometimes, I have only 1 Point to display or nothing at all on the Chart. So I'd like to check If there are some Points before to put the color of each Point.
For example :
if (ChartAlertes.Series[0].Empty == false) { //... }
but the graph shows on the X axis only that 18, 38, 41
for (int k = 0; k < semaine.Count(); k++) { Chart4.Series["Nombre de points terminés"].Points.AddXY(nbr_num_semaine_av[k], nbr_points_Termin[k]); Chart4.Series["Nombre Total d'element"].Points.AddXY(nbr_num_semaine_av[k], nbr_element.Count()); } Chart4.Series["Nombre de points terminés"].ChartType = SeriesChartType.Line; Chart4.Series["Nombre Total d'element"].ChartType = SeriesChartType.Line; Chart4.Series["Nombre de points terminés"].IsXValueIndexed = true; Chart4.Visible = true;
I am currently making a line chart of Ajax control toolkit referring to an article [URL] .....
It works fines as described. My question is how to reverse Y axis of the line chart.
I need to place 1 (not 0) at the top of Y axis and biggest number near the bottom with some margin from axis X. The described chart is biggest number neat the top and 0 at the bottom.
I have created a bar chart which gives me the appropriate data as i required but the only problm in it is that i have inherited a jquery file which gives the variable and using that variable only i can set its values.
Now i want the bar_width/bar to be in the middle of the co-ordinate line i.e
In the above image, it can be seen that between the bar and the co-ordinates there is a space and i want to reduce that and want the bar to be displayed in the center.
I work with a charline (ajax control toolkit) and I want to manipulate from code behind but I do not really know how! I have an example but the data are in the aspx code.
<ajaxToolkit:LineChart ID="LineChart1" runat="server" ChartWidth="450" ChartHeight="300" ChartType="Basic" ChartTitle="United States versus European Widget Production" CategoriesAxis="2007,2008,2009,2010,2011,2012" ChartTitleColor="#0E426C" CategoryAxisLineColor="#D08AD9"