I'm trying to set the minimum and maximum x and y axis for a chart.I'm using the next
Private Sub Chart_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
frmMenu.Enabled = False
[code].....
I have the smallest dataset in the world that simply consists of a month (text) and and amount. I want to produce a chart showing the month along the y-axis and the value up the x-axis. How do I do it? I have dragged the chart control onto the report page and populated the dataset. The chart shows but nothing like what I would expect. Just to make it simple I populated the dataset with an amount equivalent to the month number so it should show as 1 in January, 2 in Feb etc...However no matter where I drag the dataset's column names I don't get what I want. Where am I going wrong?
I use this simple loop to populate the dataset:
dsSales.Tables("Sales").Clear()
For i As Integer = 1 To 12
dsSales.Tables("Sales").Rows.Add(MonthName(i), i)
Next
ReportViewer1.RefreshReport()
I get this as a result:
MS released the new MSChart for .net 3.5 sp1. I'm trying to get the hang of it in VS2008. One big issue I have is that if I have no data plotted the chart area axis's aren't drawn. Does anyone know a way around that? That seems like a pretty basic/common issue.
View 6 RepliesI'm having problem with MS Chart chart type column. If there are only 9 bar in the chart like the following picture, then the axis-x label show up properly.
However, there are more than 9 bars bar the chart, the axis-x label wont show up properly, some of them just dissappear.
Here's my mark-up for the chart:
<asp:Chart ID="chtNBAChampionships" runat="server">
<Series>
<asp:Series Name="Championships" YValueType="Int32" Palette="Berry"
[Code]....
I don't know it works with only 9 bars? Is there any way to make the chart work properly? Also, if possible, how to make each bar have different color.
I am using the MSChart object in VB2010. Live futures data is put into an array, then added one point at a time to a line chart (Chart1, one line only) using (1):
frmChart2.Chart1.Series("data").Points.AddXY(sec10, spreadarray(0, sec10))
All fine and good. However, by the time a few thousand data points have come through, its getting hard to see the detail in the chart, therefore I reset the x-axis so that I just see the last 200 (say) points, using (2):
Chart1.ChartAreas("ChartArea1").AxisX.Minimum = frmPrices.sec10 - CLng(lstChartpts.Text)
...where frmPrices.sec10 is the total number of data points, and CLng(lstChartpts.Text) is the number of points required. So if I have 1000 pts, and I wish to see 200 displayed, the AxisX minimum in this case is 1000 - 200 = 800. Points then start to build again one at a time. I am happy with this except that the Y-axis scaling is still taking into consideration all 1000 data values, so need to reset the Yaxis maximum and minimum. No problem (3):
Chart1.ChartAreas("ChartArea1").AxisY.Maximum = (max of the last 200 values + a small increment)
Chart1.ChartAreas("ChartArea1").AxisY.Minimum = (min of the last 200 values - a small increment)
The problem comes in when I want to change the number of points to display back to "ALL". I could re-write the code to use the max and min of all values, as in (3), but I'd rather just reset the yaxis back to the autoscaling that the chart started out with. I've looked everywhere for a property or method to do this! Or is there a way to autoscale the yaxis according to only the displayed values?
I have Date and Time available in xaxis() array format. I would like to assign this to x axis of the MS Chart. My all other data is in datatable format and already have assigned series to this values.Chart1.Series(0).Points.DataBindXY(xaxis, yaxis).. but it gives me error as i do not have valid values for y axis.
View 2 RepliesI am busy with a routine that will draw a bar chart.The X-axis is from 0 -100, no problem. The problem is the Y-axis.it will range from 0 to whatever the highest y-value will be.
My problem is that the y-axis should still be divided into 10 intervals, and the lenght of my y-axis should be the same in my picture box.I am using an array to fill the values, chartdata (0-9). It gets 10 values from the program. the values are 0 -10, 11 -20,21-30....91-100 . here is the code. It is working, but my Y-axis is messed up. Printing the labels of the y-axis is a problem.
Private Sub PictureBox1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles PictureBox1.Paint
Dim chartData() As Single = {mark0, mark10, mark20, mark30, mark40, mark50, mark60, mark70, mark80, mark90}[code]......\vb
Using the System.Windows.Forms.DataVisualization.Charting objects/namespace, am having problems getting by chart to sort axis of dates properly.My data looks like this (dates in US format):
Product Quantity SaleDate
A -- 2 -- 5/1/2011
B -- 1 -- 5/1/2011
C -- 1 -- 1/1/2011
B -- 2 -- 2/1/2011
I'm creating a stacked column graph like this, where dv is a dataview of the datatable:
vb.net
chSales.DataBindCrossTable(dv, "Product", "SaleDate", "Quantity", "") chSales.AlignDataPointsByAxisLabel() For Each cs As Series In chSales.Series cs.ChartType = SeriesChartType.StackedColumn cs.YValueType = ChartValueType.Int32 cs.XValueType = ChartValueType.DateNext
So this produces a stacked column graph with 2 A's, 1 B in May 11, etc But the date order is Feb, Jan, May, regardless of how I sort the datatable provided to the chart.
I am working on simple handover process from one mobile station to other. I got three proposed results service disruption time, network entry time, connection set up time. I also have the result of these three as by using some conventional way and got improved these three delay results by proposed way. Results are store in textboxes. Now i want to show graphically. E.g. I want to show conventional service disruption time on x axis and proposed service disruption time on y axis or vice versa. Let suppose I want to have a scale on axes from 1 to 3000 milliseconds. Then I want to show how purposed scheme is better. I am using VB.Net 2008.I have created chart. I also studied MS chart for windows forms samples environment. Also applied different chart properties like titles, series and others, But I am not able to make x and y axes scales. How to get values on the axes and how to generate graph? [code]
A chart element with the name '0' could not be found in the 'ChartAreaCollection'.i also tried using ChartAreas(Default") but i am getting same idea.I don't get what for this chartAreas value in parenthesis is used.
There are plenty of references on the Internet on MSChart (AxMSChart)for Visual Basic 2008, but the published code seems to have all sorts of problems. I am a novice and trying to get a line chart with scaled dates on the x-axis.
View 1 RepliesI am using MS chart control .net 4 framework in Visual studio 2010 using Windows forms. I am having an issue with the scale of the primary x axis on a user input from a text box on a button click. I am also using both the primary and secondary y axes which work on a user input.
I have checked the settings for each axis and they all have the same settings. I don't see why both y axes work on the user input and the x does not.
The following is the code I am using:
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Chart1.ChartAreas("Area1").AxisX.Minimum = Val(XPrimeMin.Text)
[Code].....
I have a data point with a y-value of 1 being plotted, the MS Chart control will use increments of 0.2 on the y-axis. How can I force it to not use a decimal, keeping in mind I will have values of >100 so I can't just force an increment of 1 on the y-axis?
View 1 RepliesI'm seeing a strange problem with the labels on the X axis of my charts. I've setup two chart areas and aligned them (which displays fine) and the user can manipulate the chart by selecting different date resolutions (Year, Month, Day, Week, Hour) and different time periods.
The issue I'm seeing is that if a user selects say Months as the date resolution the X axis label display is inconsistent. If a fairly broad range for the dates is selected the X axis displays absolutely fine but as the date range narrows the X axis starts to duplicate labels ( please see the attached images). The second Image had a date range of 1st of May to 1st of August and as you can see the labels are duplicated. This is my first go with the chart control so I could be missing something basic. [Code]
I have a P/L chart which has a left scale (Y axis) which starts from a negative value. I want to format the axis labels (the major tick mark labels) so that the negative ones are red.
Something like;
If cht.ChartAreas(chtarea).AxisX.MajorTickMark.Value < 0 Then
cht.ChartAreas(chtarea).AxisY.LabelStyle.Font = New Font("Verdana", 9.0F, FontStyle.Bold, Color.Red)
[Code]....
Of course that doesn't work since MajorTickMark doesn't have a value property. How does one make this work?
I'm trying this example but it doesn't seem to work. It gives a IndexOutOfRangeException:I'm using a txt file where the columns are Tab seperated.)
Imports System.Windows.Forms.DataVisualization.Charting
Imports System.Data
Imports System.Data.OleDb
[code].....
I am having trouble in getting the coordinates of x-axis and y-axis in low level ouse hook...all I am getting is values in x-axis listbox and in y-axis listbox I am getting zeros......why? and my second problem is I am calling the setcursorpos
function in a for loop because I want to automate mouse movements and clicks, but setcursorpos function is not working , maybe because I am getting the coordinates wrong.....here is my code
low level mouse hook
Public Class MouseAutomating
Inherits HotKey
Public lstbox As New ListBox
[code]...
I have a chart in Excel that I'd like to use a subtitle on. There is no SubTitle Property on the chart object, so I looked in the Excel User interface and found that you can only create a sub-title by using a text box. The text box looks like its associated with the chart, not the worksheet, so how would I access that text box from code?
View 1 RepliesI am having some major problems with the code in VBA and recording a macro didn't get me anywhere nor is the VBA help file. I have to have it so that I can input a values for the x axis rotation and the y axis rotation so that my 3d surface graph will rotate whatever values I input, the 3d surface graph will rotate those degrees. I also have to have a method for having the default rotation. I was also wondering how to put scroll bars for the x and y rotation. The only other thing I am having trouble with is having an input to check box for right angle axes. So far I have two cells for entering the x rotation value and the y rotation value. I also already have my 3d surface graph.
View 3 Repliesway to switch the X and Y axis?
View 1 RepliesI have successfully created excel application, workbook, worksheet and graphs in excel through vb.net, but I am not able to choose which data to plot on teh x-axis when I plot graphs.I don't really know how to do this even in excel itself, and googling did not help at all...how to create a graph with desired values on the x axis in excel through vb.net, that would be nice.
range1 = Data.Range("A1", "B" & (t2 - t1) / i)
graph1.SetSourceData(Source:=range1)
This is my code, since I have index (t2-t1)/i as the index of the data I want to plot on the y-axis, and I want to plot all A1 values on the x-axis.
how do i work with the Z axis?If i were to make a video game and i wanted it to be 3D in graphics how is that done?
View 7 RepliesI am trying to develop a application that will invert my mouse but that will run in the background of my computer.
View 2 RepliesI'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
I have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
My requirement is to graph (scatter graph) data from 2 arrays. I can now connect the data from the array and use it on the chart. My question is, how do I set the graph's X- and Y- axes to show consistency in their intervals?
[Code]...
How do I dynamically add or remove a chart series on a WinForm. To date all my MS Charting experience has been dealing with ASP.Net charts with static sql select statment to a SQL Database. In the new project that I have been assigned I have different cities with different amounts of points that they want monitored. One city might have 3 an another might have 5 or 7 so I can't hard code the amount of series that I need. It needs to be set up so the amount of series can be flexible depending on the city selected and then display those points on the chart.
View 4 RepliesWhen i'm tryed to print Data chart the resolution of the chart changed as shown:
View 3 RepliesI've got a datatable with two columns "Status" (string) and "Total" (integer).
Status Total
Success 34
Missing 2
Failed 10
I want to databind this into a pie chart with each Status per slice but I'm not sure what method of data binder is required?
I am using microsoft chart controls in VB.net. The graph data currently comes from my database, but all the series and chart formats were made before runtime. I want to know how to make charts on runtime, being able to select the x axis from my dataset and multiple y columns from my dataset.
View 1 RepliesI can not figure out how to get the chart to display the labels. When I try and add labels, the lines get messed up. Also, if I try and do multiple lines it does not always work out very well. I tried different ColumnLabels and they behave very strange as well. What I want is to be able to have several lines. Each with their own label. And also, I want to specify text for each point at the very bottom of the graph. Let me know what suggestions you have. [Code]
View 3 Replies