Im trying to create a Graph on a 2nd worksheet. the reference data of this graph is from the 1st worksheet.I was able to highlight a specific cell for its source data but the problem is it will highlight on the 2nd worksheet in which my data is at the 1st worksheet. The problem is I don't know how to make it read from the 1st worksheet..
Below is my code:
Public Sub _autoGraph()
With exBook.Worksheets(2)
Try
[code]....
i am a newbie to visual basic 2005. i have a excel file contain x value and y value of points.i wan to plot a graph using these few points.after that display the graph in the vb.How can i do that??
View 2 Repliesdoes any one know if this is possible and if so , how? importing a excel graph and viewing it on a vb form? sample code would be very nice
View 1 RepliesI have a project to make a GUI using VB.net and retreiving data from an excel spreadsheet every three minutes and draws a graph in real time. The excel file is filled every 3 minutes by a new value (level of water in a tank).As I made started making this interface and I have a problem with retrieving data from a cell of the excel spreadsheet and update this action automatically every three minutes.
View 3 RepliesIs there a way to draw a graph in real time. The excel file has one column with the time in sec.(x) and the other column is data(y). The examples with charts I've seen is about converting to a picture, then paste it to a picturebox.
View 2 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?
Private Sub CreateChart()
Dim time2, tp As String
Try
[code]....
I have this:
Private m_PerformanceCounter As New _
System.Diagnostics.PerformanceCounter( _
"Processor", "% Processor Time", "_Total")
[code]......
I have built an Access 2007 database with some data stored in it. I have managed to export data using VB2008 from that database to Excel 2007 and have it automatically draw charts based on this data and a query in the Visual Basic Code. One of the results looks like this:
View 3 RepliesHow can i use zed graph web to graph a dataset or datatable, the only examples i have found use test data.
View 2 RepliesI have 2 blocks of code, if someone could help me put them together I would get the functionality I am looking for. The first block of code downloads a gridview to excel using the download dialog I am looking for:
Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
' Verifies that the control is rendered
End Sub
Private Sub ExportToExcel(ByVal filename As String, ByVal gv As GridView, ByVal numOfCol As Integer)
Response.Clear()
[Code]...
I have to draw a bar graph in my vb.net program. I used AxMSChart to create a graph. Everything has gone fine but when i published this and run on Vista PC, all form was good except my form includes MSChart. It says class not registered.So i have to draw a graph except MSChart tool.
View 10 RepliesI'm a huge music person (got my own lil record thing going) but I'm wanting to design a program that would make music in my way. I have a decent amount of background knowlege of Visual Basic and Java I'm just wondering how could I execute this whole project. The Project is making a MPC Sampler. MPC is a drum machine; a machine with buttons that once you press it that it will play a sound from a drum (ex: snare, kick, tom, ect.) . So I would want to make some pads on my program that each have their own sound. Total of 16 pads. Which the design wouldn't be hard to make nor would the functionality of it having the play back sound (in my opinoin it wouldn't be hard atleast). But the thing is I wanna map out these pads to number keys on the number pad or keyboard. I'm not so sure how to do that. But that's all the easy stuff...
Also finding information is making a sound directory. What I mean by this is that I want to make a User Interface that will open up a file directory of sounds and the user can select what "kick" or "snare" sound he may want for the kick or snare pad. I don't know how to do that or even know what to search; neverless I don't know if this whole project idea is a good idea for Visual Basic or another programing language.
Also LATER ON I am wanting to add a record and export function that alows users to..well...record and export their beat or instrumental ha. That doesn't seem too too complex (mainly due to the fact that all it needs to do is record the users key strokes and then show them and play the sounds, but obviously it would get more complex than that.)
Here is an image of one of many MPCs but one with a directory - [URL]
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
I am looking for Graph libraries for .net. Are there any out?ps: I mean GRAPH libraries, not graphics nor charting libraries!
View 12 Repliesneed to code up a bar graph in vb.net..
View 1 RepliesA part of my project is related to the dynamic data that stored in excel or access (anyone). i need to create a program which can automatically display the graph for these data. Just let say there are three data in excel or access[code]...
how can i display the graph for these data in visual basic?
I downloaded mschart20.ocx manually and register it with regsvr32.exe bu it gives an error ven I tried to launch my program. link to set up mschart property to my visual studio 2008 prof.edt. I need to draw a x/y graph with visaul basic.
View 1 Repliesi am to generate a line graph in vb.net. The graph should be something dynamic. I have a program calculating total distance, therefore in my output window i have iteration number and its corresponding value.
I have to plot the graph as iteration number by iteration value.I have tried an offline graph where i saved the values of the iterations and then draw the graph with the values.
But this is not what i am actually suppose to do. The graph should be generated simultaneously as the processing is being done. I am finding this a bit tough to do.
I have a CSV file in my working directory and dont know how to load in into a graph in VB. I already loaded my chart into the form and its called "Chart1" with "Series1".
The CSV has the following structure:
Date Value1 Value2
27/04/2012 45.1 60.1
26/04/2012 45.2 60.2
.. ..
how to extract this data from the "*.csv" file and put in it a graph where the Date is the x axis and the Value2 is the y axis.
I need to add a title to a graph? The code I run to create the graph is
<strong>Dim strConn As String = connectionstring
Dim conn As New SqlConnection(strConn)
Dim sqlProducts As String = "SELECT * from VW_OEEBrakeDowns_ByYear where Year ='" & Me.lbyear.Text & "' and LineNumber =" & Me.lbline.Text & ""
Dim da As New SqlDataAdapter(sqlProducts, conn
[Code] .....
I want to plot X,Y points by using visual basic. Which command do I use? Do I need to import a specific component? I don't' want to use use Excel.
View 3 RepliesI want to develop a graph application in VB.Net (VS2008). I have many point with (x,y) values. There I have calculated angel and radius by Pythagoras theorem. How to draw line with X,Y co-ordinate with scaling and put the point into this graph.......
View 15 RepliesI was writing a program on a web form which is reading a file and then plot the file as a 2d graph.
the file looks like
c1
number1
number2
[Code].....
where c1 c2and c3 is the header which the readfile stream should ignore and the total "number" numbers are decided by the user which can be a variable.
the graph will take the c1,c2,c3values as x-axis and the number values as y-axis.
how can I draw the graph from reading this file? can some one kind enough to show me some code?
whether I can use MS Graph that come with MS Office in VB.NET and how?
View 4 RepliesI want to create an app for Windows that displays a graph. I want to plot points on that graph.
I can't find a Toolbox control for this.software developer
I wanted to plot a graph for one of my application in VB.net. I want a Time (X-axis) Vs Temperature (Y-axis) graph, where:
1. X- Axis has vertical lines every 10 minutes. So there are 6 vertical lines between 1 hr. The labels on the Axis should be written at every hour even though the vertical lines are at every 10 minutes. (Eg: 10:00, 11:00, 12:00, 13:00, 14:00...)
2. Y-Axis should have horizontal lines every 10 degrees C. So there are 10 Horizontal lines between 100 degrees. The labels on the axis should be written at every 100 degrees (Eg: 0 deg C, 100, 200, 300...)
On the Y-Axis of a bar graph, how can I display descriptions as the scales instead of numbers? I don't see anywhere that I can do that.
View 2 RepliesI am writing a VB program that measures the voltage on a circuit and then graphs the voltage value. I read what the voltage is at ever milisecond and load that value into an array and shift all the data one to the right. On each timer tick i regraph the data.
The problem i am having is on each tick i erase the picturebox then i redraw the graph using the new array. Because of this the further out the line is from the start of the drawing processes the less it shows the line. You get a flicker effect. I have been seeing if there are ways to remove the flicker but the few things i have found have to deal with doublebuffered but i do not think that is the issue here. I think i need to find some other way to clear the picturebox.[code]...
I'm using the code below in my old VB6 application to show a graph of the current upload speed of the application. Image of the graph is at the bottom of this post.
I'd like to convert it to .NET, but I'm not really sure how to do it. Expecially the Polygon API is giving me headaches. I guess I can use DrawPolygon, but I'm having problems with the second parameter (converting Pts to System.Drawing.Point) and also the third parameter that DrawPolygon doesn't have. I'm not looking for anything fancy like the chart control, but like to get the graph as shown in the image below.[code]....