Draw A Graph/chart With The Results Of The Queries In Excel?
Jan 24, 2011I 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 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 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 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 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 RepliesMy 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]...
I'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[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 RepliesAre 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"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]...
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
View 5 RepliesI 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 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'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'm trying to draw a waveform graph(from mp3 & wav), I found this so far.
View 9 RepliesI 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 Repliesthe vb.net/ vb2008( i'm using vb2008) to draw a graph based on x and y axis.. and find the peaks in that graph. Urgent needed
View 4 RepliesBased 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?
View 2 RepliesI have series of video files that i need to automatically draw some line over through to the en. The line varies, the values will be provided, is this possible in vb.net?
View 1 RepliesI am having problems passing data from one form to another form opened from the first form.Here is my scenario: I have my start-up form. From this form I open a form by using the following:
[code]...
I use this because I want to be able to open multiple forms from the start-up form.Then from the PartyDetail form I open another form to display order details, like this:
[code]...
I want this order details form to be able to get a partyid variable from the party detail form.This works, but depending on the order that I open the forms the variables are incorrect Example:If I open the first PartyDetail form and then open the OrderDetail form, it works correctly. I can open as many PartyDetail and OrderDetail forms that I want and the variables are correct.But, say I open a PartyDetail form and then open another PartyDetail form and then open the OrderDetail form from the first opened PartyDetail form, it displays data based on the second opened PartyDetail form instead of the first. Basically, I want to be able to open multiple PartyDetail forms and then open OrderDetail forms based on whichever PartyDetail form it is opened from.Right now I am using Public Shared variables on the PartyDetail form and accessing this variable from the OrderDetail form. I suspect this is my main problem but don't know the best way to pass the variables from the PartyDetail form to the OrderDetail form.What would be the best way to do this?
Will any of the free light-weight charting libraries; ZedGraph or NPlot, be able to draw a simple graph similar to attached image (no waste of space, and with colored plot areas)? This plot will act much like the task manager "CPU Usage" plots, with update of last value every 500ms, but only making a new datapoint every 1 minute or so.
Or is this so extremely simple that it's better to hard-code it? What classes should I look into for this?
I am VERY new to Access 2003 and learning VBA slowly, but surely. I'm in need of an easy,quickway to take the results of 3 different queries and paste/overwrite them into the "Data"ab on 3 different Excel 2003 filesI am ableto use Macros to copy the queries into 3 new tabs, but can't seem to get them to overwrite.
View 2 RepliesI'm making a cricket project, and I'm trying to insert a bar graph that will update as I score the match, showing the total for each over. The code I have so far is below, at the moment I'm trying to draw the graph into a picture box, is this correct? Also, if the below code is ok, how do I call the sub?
Public Sub graph_paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles graph.Paint
Dim total(20), i As Integer
For i = 1 To 20
total(i) = over(i, 1) + over(i, 2) + over(i, 3) + over(i, 4) + over(i, 5) + over(i, 6)
[Code] .....
I am doing a bar chart project. my project should looks like this:
The problem i have right now is that i don't know how to draw the rectangle in the right way. my rectangle start to draw at the left top, how do i fix my code to make the rectangle draw start from the bottom? Also, i know how to draw string of my each input value, but i don't know how to print data values inside each bar, centered horizontally and vertically. This is what i have done so far
Here is my code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Blue As Brush = Brushes.Blue
Dim Red As Brush = Brushes.Red
[CODE].........................
I want to draw graph in visual basic 2010 form which changes with time. Just like the CPU usage history graph in the "Windows task manager" dialog box. Thats time vs. usage graph. I want to make applications with that kind of graph.
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 Repliessomehow combine the results of separate Fill queries on a single dataset?Basically, I'm trying to implement a 'Filter' function, whereby, the user can filter the records in a DataSet according to specific criteria.
View 4 RepliesI am doing a registration system, and my system should have a report by using a bar/pie chart.How i want to create a bar chart with value generate from database. what component should i have to create those chart? im using visual studio 2008 and mysql query.
View 5 Replies