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.
[Code]...
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]...
Are there any good free graph/chart dll's that anyone knows of?
View 5 RepliesI 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?
View 2 RepliesI would like to include a bar chart in my program. My present tool box does not have that control. how I can include that control in my tool box.
View 2 RepliesI 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
View 5 RepliesI'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?
View 3 RepliesI am trying to make a line chart and from what I've read using the chart control is the best way to go about it, but I have no idea how to do that.
View 4 RepliesI 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?
I want to insert an image of a chart(graph) from vb .net to a Word document. I can open a new doc but I can't get the chart exported to it.
View 3 RepliesI 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.
View 11 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 RepliesAnyone 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.
View 7 RepliesI 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
[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 RepliesIn our company we are using PHP to display graph from statistics in SQL over webpage. So anywhere just access the website and input the date will display statistics over the webpage of the company.
My question now is, will VB.net can do that to link SQL and display it over the webpage? Or do I need to have special software to use?
If VB.net can do it? Is there any tutorial link you can recommend for me? Video link much better.
i would develop a program that displays the graph/spectrum of a WAV sound file located on the computer.
View 2 RepliesI am wondering how one would go about using the graph control to display a bar graph that shows trends from my database.They are rather easy trends. I am building an industrial issue tracker and I would like for it to show how many issues were submitted each month for the last 6 months and also how many issues in the last month were of certain types that are categorized in my database.
View 1 RepliesIs it possible to fix a web browser to a certain spot? Example, i want it to display the graph in this link, and only that graph, nothing else. Is there a different way i can do this? [URL] Also, the users will be searching items to display that items given graph, it;s not the same every time.
View 10 Repliesif there's a way to just display the latest Symbol when drawing a graph. My app displays "real time" data from a pointPairlist and I want one graph just to be a + mark with no trace.
Dim myCurve As LineItem = m_graphPane.AddCurve("", m_pointsList, Color.Red, SymbolType.Plus)
This will show a red line with a + with every pointpair, I just want to display the latest pointpair, as an +.
I have used MSChart control and created line graph. when i move my mouse over the graph, i want to display X-axis value and Y-axis value in another label above the graph.
View 2 RepliesIs there a way to get Visual.net to display the sound coming in the microphone as a graph on the screen? for example it would show the frequency and intensity of the waves.
View 2 Repliesi have recently installed Visual Studio 2010 Professional and I am currently coding in VB. I am trying to display a bar graph (pulling from MS SQL database) for certain criteria, but I do not have a "Chart" option in my Toolbox section. I have a licensed software and do not know why the "Chart" option is not present.
View 11 Repliesthe disply color buttons click even procedure shold display the color of the item whose item number is entered. all item numbers contail eactly five characters(12b12). my problem is i can not get it to disply a color in the lblcolor control. it displays the item number.
[Code]...
The first field is the id The second field is the date The third field is a double number Individually, chart1.series(0) and chart1.Series(1) work But, when one after the other, like below, only the first date shows in position, the rest are not visible.
[Code]....
i have write following code in form load event
import system.data
Dim conn As New SqlClient.SqlConnection
On Form Load Event
[Code].....
I'm trying to present results on an aspx web page where a store procedure parameter is defined by a dropdown list control on the page. I have followed this guide from Microsoft and have my resultset presented in a DataGrid view. But I cannot seem to adapt it to present the resultset in a chart.
As you can see from my VB code below, I thought it would simply be a case of adapting the GridView databind to a Chart. I have tried various other options, and have successfully generated my data in a chart using a hard-coded parameter in an SQL statement on the ASP page. But when it comes to using the control, I get an empty chart.
Below is what I have so far.
Imports System.Data.SqlClient
Public Class Report
Inherits System.Web.UI.Page
[Code].....
I wrote the following program in vb.net. I am reading 2000 data points XY points from csv file into oledb connection and displaying it into the MS cHART but it is displaying only first 500 points...
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:;Extended Properties=""Text;HDR=No;FMT=Delimited""")
Dim da As New OleDbDataAdapter()
Dim ds As New DataSet()
[code]....
I am developing an application with multiple picture boxes, each displaying a line graph. I want to be able to have a label following the mousepointer showing xy coordinates of the point. I also want to allow a user to zoom in on a specific picture box by double clicking on it. The code does what I want as written (changes backcolor so I know double click event fires) except moving the position of the label to follow the mouse pointer.
However if if uncomment the line in the MouseMoved sub:
LB.Location = New Point(e.X, e.Y)
Then the label moves as desired however the double click event no longer fires.
Public Class Form1
Dim PB As New PictureBox, LB As New Label
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Controls.Add(PB)
With PB
[Code] .....
I have an excel data and able to draw an pie chart from vb.net.
I should be able to add the data table below the pie chart from vb.net