In the control Chart, I add few points, selected from the database:
var Diagram_1 = Razrez_D1.Series ["D1"];
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.SelectCommand.CommandText = "Razrez_D1";
sqlDA.SelectCommand.Parameters ["@ date1"]. Value = Session ["date1"]. ToString ();
sqlDA.SelectCommand.Parameters ["@ date2"]. Value = Session ["date2"]. ToString ();
sqlDA.Fill (dataSet1, "Razrez_D1");
sqlDA.SelectCommand.CommandType = CommandType.Text;
for (int i = 0; i <dataSet1.Razrez_D1.Rows.Count; i + +)
(
string name_s = dataSet1.Razrez_D1 [i]. Name.ToString ();
name_s = name_s.Substring (name_s.IndexOf ('№')). Trim ();
Diagram_1.Points.AddXY (name_s, dataSet1.Razrez_D1 [i]. Count);
Diagram_1.Points [i]. BorderColor = System.Drawing.Color.Black;;
Diagram_1.Points [i]. BorderWidth = 1;
if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count)> 5)
(
Diagram_1.Points [i]. Color = System.Drawing.Color.Red;
)
else if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count)> = 4 & & Convert.ToInt32
(dataSet1.Razrez_D1 [i]. count) <= 5)
(
Diagram_1.Points [i]. Color = System.Drawing.Color.Yellow;
)
else if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count) <4)
(
Diagram_1.Points [i]. Color = System.Drawing.Color.Green;
)
)
The problem is that the points on the X axis are signed that way: first is not signed, second is signed, third is not signed etc How can I sigh all points?
so I have 3 series that are created from Cross Table Data Bind. Unfortunately some of the points are missing. Is there an algorithm I can use to cycle through the datapoints for each series and insert empty points to the correct spots so that my data is displayed correctly?
I am currently using the new asp.net chart control.In this control i am not setting the maximum, minimum and the interval value because they are dynamic.ow once the graph is populated from database, the asp.net is only generating 4-5 points on the y -axis, i want it to show at least 10 values.But i am not sure how to increase the number of points on Y & X Axis.
I have an ASP Chart (v4) which displays the data I need perfectly. I want it to show labels at the top of the data points and I am having some difficulty with it.
Here is my code that works for both series but does not display the labels:
<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) { //... }
I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
I have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
i'm trying to create a stacked bar chart on a vb web form using vs2010.My data source returns:
Error in Functionality Awaiting on Supplier
1IMT IssuesmActive6
IMT Issues,Awaiting on Supplier
2,IMT Issues,Awaiting on User 4
IMT Issues Closed 120
Login / Password Active
But I can't get this into a stacked chart. I know I must have to do quite a bit of work declaring what the series are and soforth, or having a different dataset but can't find any documentation on it.A link to some documentation or an example of a stacked chart from an sql datasource would be much appreciated.
I started using the awesome chart controls with my asp.net apps recently and so far they've been nothing short of breath taking. Right now I have a weird problem, on the first load of my page, the chart control appears correctly and the tooltip is correct, however, when I update it with new data, the chart displays correctly, but the tooltips are for the previous set of data.
I hope this makes sense. The first time I load the chart, the pie chart segments and tooltips are correct, after a partial postback (to get the new data), the pie chart segments are correct but the tooltips are for the previous data set.
Basically once the tooltips are set the first time, they can't be updated after that without a full page postback.
Here's how I set the tooltip:
[Code]....
Anyone else noticed this behaviour and have a work around?
Currently my only workaround is to check for a partial postback and not render the tooltip, which I'd rather not do as the tooltip display actual statistical data as opposed to the pie itself (which uses percentages).
I have a chart with Y1, Y2 and X.X is date time.Issue is first and last point of the line chart is plotted on the Y1 and Y2 axis. They do not leave any space.I would like to leave some space before and after each series (some distance from Y1 and Y2).So instead of this,
I'm trying to build a chart in my application which will act as a client for an ASP.NET 3.5 web service that I created. The error I get is as follows:
Series data points do not support values of type System.Data.DataViewManagerListItemTypeDescriptor only values of these types can be used: Double, Decimal, Single, int, long, uint, ulong, String, DateTime, short, ushort.
I've tried various ways to resolve this but can't. This error points at the chtStats.DataBind() line in the code below:
I am new to asp.net. I am suppose to continue a project. The previous person has created a line chart and I have to create a bar chart. However I do not know how to create a bar chart. Could u email me for the code as I realise that I can't upload the files.
I need to create the following stacked bar chart using the MS Chart control: [IMG]http://i54.tinypic.com/2d1ti05.jpg[/IMG]
My table structure is as follows:
PEStaffAssessmentID int PESubmissionID int Q1_ConfidentDelivering int Q2_ProfessionalAttitudes int Q3_LeadershipEffective int Q4_SupportedByPeers int Q5_AssistedInexperienced int Q6_ConfidentKnowing int Q7_AbleToTalk int Q8_CommunicationEffective int Q9_ConfidentSupporting int Q10_TeamShares int Q11_CareDeliveredSafely int Q12_MinimumMaintained int Q13_MeetOwnExpectations int Q14_SpendEnoughTime int Q15_ProvidePhysicalCare int Q16_ProvideEmotionalCare int Q17_SpiritualCare int Q18_ProvideCare int Q19_ManageWorkload int Q20_HighestStandardCare int Q21_MoraleLevel int Q22_RateCareReceived int
So each column in my datasource need to represented by a row in the graph. and the contents of the stacked bars should be the values in the fields. how to set up the series in the chart object to reflect this?
In my web forms application I have a site.master page with an update panel (Java Script ToolKit). Inside the update panel I have a survey and a columns chart to show its results. The chart properties are
When the user votes, his/her vote is stored in a sql server table The chart is rebound to its data source The chart visibility is set to true and the survey's questions are hidden. I've been trying to set the columns for the maximum and minimum values to a different color using the code I found in "Samples Environment for Microsoft Chart Controls" [URL] under Working with Chart Data Data Manipulation Finding Data Points Find Maximum and Minimum Values:
[Code]....
I have not got the columns to change their color. I have put the code inside every event handler I could think of (after it failed to work inside the page load event handler): Inside the chart Init, load, and pre_render handlers. Inside the click event handler for the voting button (before and after I call the chart.DataBind() method). Inside the page pre_render handler. Inside the ToolKitScriptManager pre_render handler. I checked the code behind the environment samples. All, to no avail.
I m having a problem in showing chart with datatable. I want to show my chart as shown in below image. How can i do this in ASP.net using MS chart controls