Generating Multiple Series For Chart From Same Data Source
Jul 6, 2011
I am importing data from an excel file, and it is stored in a dataset. The data is then filtered with a binding source, and that data is outputted into a datagridview. The filtered data in the datagridview contains data for 2 identification numbers. I want to graph each ID number in a chart on their own bar, in either a stacked bar graph, or a double bar graph.
I am having trouble assigning each series to an ID number: I have tried using multiple binding sources, but each seems to override the previous giving too much/too little data. I have tried using multiple datagridviews, however I cannot assign more than one datagridview as the datasource for the chart. The code I have pasted below outputs a double bar graph, however both bars graph the same ID number.
Private Sub dataButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dataButton.Click
Try
Dim cnRange As String = "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & strFileName & "';" & _
"Extended Properties=""Excel 8.0; IMEX=1; HDR=No;"""
'moApp.Visible = True
[Code] .....
View 1 Replies
ADVERTISEMENT
Mar 9, 2011
I have an ASP Chart (v4) which displays the data I need perfectly. I want it to show labels at the top of the data points and I am having some difficulty with it. Here is my code that works for both series but does not display the labels:
[Code]...
View 1 Replies
Mar 4, 2012
How do I plot multiple series (say about a thousand) on one chart at runtime?
View 7 Replies
May 12, 2012
I am trying to build a function that returns a chart. I want to have a parameter to account for times where i may need more than one series. How does one loop through to create multiple series? I would think you would need a variable for each series. The function is below. I would think that if there were 5 series that each of the "Dataseries" variables should have their own name. Do I then refer to them by index only?
[Code]...
View 1 Replies
Jan 15, 2009
I am trying to build a function that returns a chart. I want to have a parameter toaccount for times where i may need more than one series. How does one loop through to createmultiple series? I would think you would need a variable for each series. The function is below. I would think that if there were 5 series that each of the "Dataseries" variables should have their own name. Do I then refer to them by index only? Public Shared Function MakeChart(ByVal form As Form, Optional ByVal numseries As Integer = 0) As Chart
' Add any initialization after the InitializeComponent() call.
Dim SampleChart As Chart = New Chart()
Dim MainChartArea As ChartArea = New ChartArea()
[code].....
View 11 Replies
Jun 21, 2012
I have an array of type Double() (1 x n) that I am trying to quickly plot on a graph I've already set up. The only thing I want/need to do is take my array and store it as data points (y-axis values) in the series I already have. What's the best way to do this? Also, will the data points that are plotted change as my array changes, and if not, how would I replot those new points and get rid of the old points?
View 1 Replies
Nov 30, 2011
I think my subject sums up what I am interested in knowing. I am looking to create a chart where Series1 is from Table1, Series2 is from Table2 in the given Dataset. My code below doesn't throw any errors, but it appears to be grabbing the data for each series from the first table.
Imports System.Windows.Forms.DataVisualization.Charting
Public Class Form1
Public Sub New(ByVal ChartData As DataSet)
' This call is required by the designer.
InitializeComponent()
[Code] .....
View 1 Replies
Apr 8, 2012
I'm working in VS2010 on a visual basic application. It takes in serial port data, writes it to an access database, and then graphs the data.The data only comes in once every minute, so it's not like I'm building an oscilloscope. Right now, the chart is reading from the database using a table adapter and graphing just fine, so long as I keep the number of records in the database low.If I add too many records to the database, the chart shows a red "X" through it. I've played with changing the axes, but it is still a problem.I don't really need to graph the whole database.The twenty most recent records would suffice.How can I make a chart series with only a small subset of the database in it.Perhaps it cold be populated with a query?
View 1 Replies
Aug 25, 2010
I'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
View 1 Replies
Mar 23, 2012
How do I dynamically add or remove a chart series on a WinForm. To date all my MS Charting experience has been dealing with ASP.Net charts with static sql select statment to a SQL Database. In the new project that I have been assigned I have different cities with different amounts of points that they want monitored. One city might have 3 an another might have 5 or 7 so I can't hard code the amount of series that I need. It needs to be set up so the amount of series can be flexible depending on the city selected and then display those points on the chart.
View 4 Replies
Jan 7, 2010
I am able to place a single series of chart data with my code but I cannot for the life of me figure out how to add a second series. I can add the Series ... I can Select the series but cannot with out errors figure out how to put data the the series' that I am creating ...
Ol' Mitch
xlApp.ActiveChart.SeriesCollection(1).Values = Rng1 <-- Error
xlApp.ActiveChart.SeriesCollection(2).Values = Rng2 <-- Error
[Code].....
View 2 Replies
May 9, 2011
I have a set of charts in a form. These are "canned" charts and will only be updated when new data comes in (typically on a monthly basis). I have created each chart by binding (bounding?) a data source to it in VS2010 using the Properties slide out window. I set the DataSource to a data source table that I set up in the .XSD file. In the Series property GUI I have set up the XValueMember and YValueMembers from the available columns in the data table I set in the previous step. I have 6 tables in my DataSet. One table relates to one Chart (Chart1, Chart2, Chart3, etc) in my form.
What I would like to do is programmatically get the data table name from the Chart properties. I have tried doing something like:
ch1Table = Chart1.DataSource.DataMember.ToString
However this fails due to Option Strict disallowing late binding. I am probably missing something obvious here but I cannot see it.
So, how do I get the bound data table name from the set properties of the chart? I am using MSChart Control 4 and VS2010 and building a VB.NET WinForms app.
For each of the 6 charts there is an associated System.Windows.Forms.BindingSource. What I need to do is programmatically get that BindingSource, then get the DataMember (which is the table name I need) for each chart.
View 1 Replies
May 17, 2011
Apply a generic template to chart series.[code]Note that the bars are unstyled while the chart seems to style just fine.The documentation regarding built-in .NET charting is woefully thin.Can anyone help me get my generic templates to work?
View 1 Replies
Jul 18, 2011
Im starting to learn how to use the chart control in VB .how you create a "new" column because atm all the time i add series it puts them side by side.Ive looked at the documentation for the control and the examples but they dont seem to cover this , or i could find it .Now how would i assign each series to a new point?So item 1 would go above column 1 and item 2 above column 2 etc.The code i have at the moment is a test code .
Chart1.Dock = DockStyle.Fill
For i As Integer = 0 To 10
Dim newSeries1 As New Series[code]..........
View 1 Replies
Jul 19, 2011
Is there is a way to remove the white box around the series label in a chart. I am using the built in chart from the toolbox in Visual Studio 2010. This is the last part I need to finish the appearance of the chart to make it look the way I want.
View 1 Replies
Mar 17, 2012
I am using a button on a form which creates a chart at runtime when the user clicks the button. it works ok for the first time but when I select the button the second time I get a square diagonal box or indexoutofrange Exception.Note: I have another button that clears the series from the chart before reselecting the button that creates the chart.
Below is the code segment
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Static Dim counter As Integer = 0
[Code].....
View 1 Replies
Apr 2, 2012
Im trying to plot the reading of 20 or more thermocouples in a single chart area.But it seems that the build in charting in vb.net can't handle that. My program just crashes when adding a series somwhere between the 14th or 18th series.Anyone know of any setting i can change or a better charting plugin?
View 2 Replies
Jan 7, 2011
imagine an array of data containing a gray scale image and you want the bar chart (say 20x20) to display a section of that image as both the magnitude of the data and its shade of gray. if you were to look vertically down on the 3D barGraph you should see the section of the image. Is this at all possible? The projetc relates to clutter intensity in a radar image if this interests you.
View 2 Replies
Dec 29, 2011
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
[CODE]..................
View 1 Replies
May 10, 2010
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
View 3 Replies
Jun 9, 2011
is it possible to have a single report from two different tables? Because I have been reading articles that are saying that it is not possible and a subreport should be implemented? Can anyone clarify this for me?
I've been retrieving the fields that I need for my report with inner join sql statement and setting it as the data source of the report that I had created but it doesn't show up when the crystal report viewer is loaded. I had the correct syntax based on testing on what is retrieved by the statement, the only problem is how should it be shown in a single report.
View 3 Replies
Oct 17, 2011
I'm working on a program that is interacting with a simple Access database. When the form loads there need to be multiple text boxes that are bound to the same table and field in the database, Inventory_Table.Quantity, to display the quantity of the inventory. From there, orders are read into the system adjusting the inventory as necessary.
I need to specify what row these are each supposed to be bound to, because right now it is binding them all to row 0, which makes sense but is not what I want. Is this possible? Heres the code I have to bind currently.
txtTopQuantity.DataBindings.Add(New Binding("Text", myDS, "Inventory_Table.QUANTITY"))
txtLegQuantity.DataBindings.Add(New Binding("Text", myDS, "Inventory_Table.QUANTITY"))
txtFastenerQuantity.DataBindings.Add(New Binding("Text", myDS, "Inventory_Table.QUANTITY"))
txtShortQuantity.DataBindings.Add(New Binding("Text", myDS, "Inventory_Table.QUANTITY"))
txtLongQuantity.DataBindings.Add(New Binding("Text", myDS, "Inventory_Table.QUANTITY"))
txtWheelQuantity.DataBindings.Add(New Binding("Text", myDS, "Inventory_Table.QUANTITY"))
View 1 Replies
Oct 17, 2011
I have created a form with three comboboxes. means
FirstNameComboBox
MiddleNameComboBox
LastNameComboBox
All fields are select ( name ) from a "CustomerName" table. "CustomerName" table is have more than ten thousand records. I am use three binding sources its worked great but it is very slow bcz three comboboxes are filled data on form loading time. I am using visual studio 2010 (visual basic).
View 8 Replies
Jul 14, 2009
I have several combo boxes which are mapped to the same datasource (an array), when user selects one combo box, all other boxes are get updated to the same selection too. what is the problem?
View 10 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
Feb 17, 2012
When i'm tryed to print Data chart the resolution of the chart changed as shown:
View 3 Replies
Oct 16, 2010
I am created a Vb.net ERP Application! In this application I handle core accounting concepts. I have handled Salebill and many of accounting form. I take salebill billno from Database by selecting maximum srno from salebill Table but whenever multiple user trying to access this form at a time, everyone gets same billno. How I handle this situation to show different bill no to different users?
View 4 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
Jun 30, 2010
I am not able to generate Multiple GroupBoxes at runtime By using below code. so, plz anyone can help me to rewirte the code....
For i = 1 To ds.Tables("tblprojects").Rows.Count - 1
Dim GroupBox1(i) As New GroupBox()
Dim CheckBox1 As New CheckBox()
Dim RadioButton1 As New RadioButton()
[code]....
View 13 Replies
Feb 10, 2012
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 Replies