I have a series of x and y co-ordinates that I would like to plot on a line graph. Can anyone recommend any simple tutorials that would get be started?I have my chart component on the form, I'm guessing that I need to declare a collection of datapoints and loop through the adding each to the graph
I have two values those are contiguously One is Time along x-axis and second is the CPU Usage in percentage along Y - Axis. I want to draw a continuous line Chart/graph what ever called.
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?
I have a chart that I plot data points onto however if the user replots the graph the old datapoints are still there hiding the new datapoints. Essentially how can I clear the chart area of a graph?
I"m having a bit of trouble getting my pie graph to work. I'm not too sure if I should be posting here, but it's about vb so I thought it would sort of fit. I've used the chart control from the toolbox, and dragged one of those across to use. I can't get more than one item to display in the chart.
I've got a bar chart on my form which when I click a button, it populates with some data showing the clients net position, which is their assets vs their liabilities. This is shown on a year-by-year basis, so the graph will go up or down accordingly. If the graph goes into negative, or is negative at any stage, I would like it to turn red, and leave the positive values green. I have no idea how to do this, or even where to start looking into the properties. I'm still new to using the charts. How can I make the x-axis labels in increments of 5 from 0, instead of increments of 5 from -1?
I have a ms access database with few tables and queries. I need to draw a graph/chart with the results of the queries in excel. Is it possible to do with vb.net coding?
Anyone have VB.Net or VBA code to ascertain if an Excel Object is positioned over (Hiding) spreadsheet data?I have code to create/position a chart object. Where would I begin to determine if there is data "under" an object.
I am working on an application that ties into a SQL database on the back end. Currently the main form contains a series of combo boxes (Graph type, data format, location, and customer), two date pickers, and a button to launch the selections in a new form. Everything works just fine except there are a couple of things I can't seem to accomplish.
Example Data:
[CODE]...........
Case Select (with commented out lines for variations attempted):
[CODE]..........
1) I would like to be able to use some sort of case statement to color the bars in my chart based on value. I have tried approaching this in a couple of different ways but neither of the options seem to work. First, I tried this (the If Not is used because depending on what values are passed to the stored procedure in SQL, different columns will be returned):
[CODE]..........
Only one series is created with this method, so I can see how/why a Select Case would set all bars the same color. I have also tried creating a series for each row in the returned dataset but it results in 22 bars of different colors, for each of the rows (484 bars):
[CODE]..........
So is there any way to modify the second set of code there to only select the value from the "Percent TMHB" cell that corresponds with Row(i), rather than ALL values from the "Percent TMHB" column for EACH Row(i)?
2) Since I am drawing/creating these graphs in a new window, is there any way to also create a new timer on the "newFrm" and have the tick refresh the data? I've struggled with this but I feel like it should be easy. Say someone chooses a "TMHB", "Percentage", "Chicago", "All" (Graph type, data format, location, customer) and launches the graph, which opens in a new window, then they want to do "TMHB", "Percentage", "LA", "All" and have both windows up, refreshing automatically throughout the day. Can I somehow store the SelectCommand.Parameters values in the new form/timer so that it will query the database again every 5 minutes?
Example code for the StoredProcedure and creating the new form:
If combo_GraphType.SelectedItem = "TMHB" Then Dim newFrm As New Form Dim newChart As New Chart
I'm only getting started with VB.Net, using VB Express 2008. Using the System.Data.SQLite wrapper, I need to read data off an SQLite database file, and chart data using basic bars, pies, lines, etc. Nothing fancy. Which component would you recommend, either open-source or affordable?
I want to picture a line graph based on my array. I can create a graph line with 3 different series, but I don't get my exact chart as in excel. As can be seen from graph in the attachment. It has additional lines. I want just the 3 curved lines, but i don't know why it create other lines. Here is the code I used:
I am currently using visual basic 2005 and i am wondering if it is possilbe to create a line graph using data similar to for example Week 1 = 40, Week 2 = 40, etc....and the Weeks as cross the X axis and the numbers from 1 to 100 on the Y axis....is this possible to implement in visual basic?
Based on some calculation i will get the (x,y) coordinates of the points to be plotted. I need to draw a line graph based on these points. Which is the best and easiest way to do so?
using vs2008 I am trying to create a line graph using vb in a windows form. I have dragged a chart onto the form, and via the properties window, through the series option have changed the type to the graph that I want, which is line. But all the time the data is displayed as a simple bar chart. How do I remedy this please to get the type of chart that I want.
I've looked around, I can't find much documentation on Line Graphs using the MS Chart Addon for VB2008.
Whenever I add the "chart" control (which seems to be the only new one in the property browser) a Bar Graph appears. I'd like to create a line graph rather than a bar graph, I don't see an option to change the kind of graph it displays. I'm sure I'm missing something simple, since I've seen people able to create their line graphs almost immediately after installing the control.
How to create a line graph in VB 2005? I will get the data from database and plot a line graph with the information i get from the database and display it out. I know i can use Microsoft chart control but i don't really know how to use that.
This isnt the first time i have posted about a graph, last time i was posting about which way i should do it, now that i have created the graph (by drawing individual lines) i was wondering what the easiest way to actually get data from a SQL database and output it as a line on a graph. here is a picture of what the graph looks like (bottom of the page) [URL]
I am trying to plot a set of data using a function I have defined as an array: Private Sub calculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles calculate.Click range(1) = min.Text For i = 2 To 100 [Code] ..... Range(i) I want to be my x values and fee(i) to be the y values. When I try to select range() and fee() as the x and y values for a series, I get an error because they are not of type double.
I would like to know a simple method to create a simple line graph, with a grid and X and Y values... I tried just drawing in a picturebox but that was just annoying and not clear... Is there any simple way to create a little graph with prefixed values on X and Y (graph should just be lines drawns from different Y values, with always the same change of X)
I'd like to do something I thought was simple. All I'd like is to take the data from a connected database, then put those values into a scrolling line graph. Preferabley with 4 lines (taking information from separate tables) on the same graph. I've connected the database and set up a script to populate it with data, but that's as far as I go with graphs.
I've downloaded 'MSChart.exe', 'MSChart_VisalStudioAddOn.exe', ChartFXLiteNet' and others, yet none work. I've also followed a tutorial here on graphs, but it's for visual studio 2005, and I don't have the options required. I'm using Visual Studio 2008 with VB.NET.