Assigning Array To X Axis Of MS Chart?
Feb 21, 2012
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 Replies
ADVERTISEMENT
Jan 8, 2009
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:
View 1 Replies
Mar 12, 2010
I'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.
View 4 Replies
May 13, 2011
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?
View 8 Replies
Dec 28, 2009
I 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
View 9 Replies
Jun 8, 2011
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.
View 7 Replies
Mar 24, 2009
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].....
View 12 Replies
Oct 28, 2009
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.
View 1 Replies
Mar 7, 2010
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 Replies
Jul 21, 2011
I 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].....
View 1 Replies
May 9, 2012
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 Replies
Aug 2, 2011
I'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]
View 1 Replies
Apr 2, 2009
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 Replies
Mar 7, 2011
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]...
View 1 Replies
May 22, 2012
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?
View 1 Replies
Aug 14, 2011
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]...
View 4 Replies
Dec 9, 2011
I'm having trouble assigning values to an array and am getting the error, "Value of type MemberFocal.Member cannot be converted to System.Array" - MemberFocal.Member is part of a custom class and I am attempting to create an array of these objects. Here is the code:
[Code]....
View 1 Replies
Feb 3, 2010
I decided to learn Visual basic because I want to see actual results and I don't see any in C++
when I was following it I get "Declaration expected" I'm going to assume that there is something wrong with the way that I'm assigning the array it's values but I don't know what to do.
Public Class Form1
Dim player(2) As String
player(0) = "Bob"
[code].....
View 2 Replies
Oct 14, 2011
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 Replies
May 6, 2009
[code] i feel that it is a waste of code and should be shrunk down into some sort of loop. [code] i know i could easily leave it the way i originally had it, but i hate having wasted code!!
View 8 Replies
Oct 24, 2009
I still cant work this out!!his is what i started off with:
CurrentButtons(1) = Button1
CurrentButtons(2) = Button2
CurrentButtons(3) = Button3
[code].....
View 1 Replies
Mar 2, 2009
I have a text file which I open and then read in 1 line at a time and split up. I then takes each component part from the split string and assign it into a variable as I go.
I then want to specific varaibles and put them into an array and build the array.
Can I read in each element and assign it directly into an array or is this was best.
also
I seem to be getting an error when I try and directly add items into an array
' myCarrier(98).EZY_Both = myCarrier(98).EZY_Both + 1 '
Structure Carriers
Public BA As Long
Public BA_Lev3 As Long
[Code]....
View 4 Replies
Dec 26, 2009
I am having a problem with objects and arrays of objects. Basically obj_stored holds how many objects I have stored in my text file, in this case t shirts. line(y) is an array that holds each line that has been read from the text file. I then use this to assign values to my array objects properties. For example I know the first line is the color of the first t shirt, second size, third price etc. Then I know the next line will be the color of a new t shirt. There are 6 t shirts in the file.
Dim t_shirt(5) As Clothing.t_shirt
Dim t_shirt_purchased As New Clothing.t_shirt
For x = 0 To obj_stored
t_shirt(x) = Clothing
t_shirt(x).color = line(y)
y = y + 1
t_shirt(x).size = line(y)
y = y + 1
t_shirt(x).price = line(y)
y = y + 1
Next
MsgBox (t_shirt(4).size)
My problem is it seems to be resetting these values after it has finished. Im creating the object each time and assigning values to it's properties but when it's finished it all resets and says 'Object reference not set to an instance of an object'. I'm new to OOP and was wondering what sort of approach i would take to doing this, if the one i am taking is wrong.
So I am aiming to:
Read everything in from the text file.
Create new instances of the objects depending on how many t shirts are stored, (5 t shirts = 5 objects)
Assign the values to my objects properties.
View 2 Replies
May 2, 2009
1. i am trying to assign button1....button81 a position in currentbuttons(81) and i currently have it at
currentbutton(1) = button1
curentbutton(2) = button2
and so forth to 81. how can i get around it into a small loop so i loose alot of the redundant code?
2. i am also having difficulty with being able to change properties of buttons in regards with..for the butons like...button1, button3, button5, button6 etc...to all be changed to a different colour.i currently have something along the lines of
button1 = system.colour,
button2 = system.colour.
View 10 Replies
Aug 19, 2010
I am new to Vb I am trying to assign to each one of the objects in an array a set of properties and I get "Object reference not set to an instance of an object."
Public Class Form1
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim pointer As Integer = 0
depart(pointer).id = "text"
depart(pointer).name = "text" 'here I get the error
[Code] .....
View 5 Replies
May 1, 2012
Am getting error in development code "Reference to a non-shared member requires an object reference." when assigning value to string array where Array is defined in a class.
Here's some sample code to illustrate problem.
Module FieldNames
'Budget Departments
Public Class GLD
[Code]....
View 4 Replies
Sep 16, 2009
I 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 Replies
Feb 21, 2012
I have a form that asks for a name, and a phone number, it has 3 buttons, a add customer button, show list button and an exit button. When the add customer button is clicked, it increments intCustomer variable, formats the phone number, makes sure only the first letters of the name are capitalized and creates an ID that is the first 4 letters of the name plus the customer number, the show list button takes ALL customers added to the array and displays them into a multi-line text box, like so:
ID Num Customer Name Phone Number
JOHN-1 John Harry Peters (111) 111-1111
Paul-2 Paul J Rodgers (111) 111-1111
Etc...
The area where I am completely lost in, is how to add the consecutive customers to the array, in the correct way. here is my code in its entirety
Public Class frmCustomerName
Dim intCustomer As Integer = 1
Dim names(9, 2) As String
[code]....
View 1 Replies
Jun 30, 2010
how to assign a 1-dimensional array value I get from a function directly into an element in a 2-dimensional array. An example would be
Dim Results(7)() as DoubleResults(0) = myFunction() ' returns an array with 5 doubles What is the correct syntax for this, if any? I'm still having a bit of difficulty switching over from Python arrays, which work a lot better, it seems.
View 5 Replies
Mar 21, 2011
I am getting an error when helping someone with their code. They are trying to create an array of Items, but gets an error at ItemStruc(counter).ItemName = Contents(0)
I am not sure why. >_>
Structure is as follows:
public structure Item
dim itemName as String
[Code].....
View 2 Replies