Chart Control - Possible For Bar Graph To Be Of Multiple Colours?
Mar 15, 2012
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?
View 3 Replies
ADVERTISEMENT
Feb 25, 2011
I have an VB.net application in which I have imported the MSchart control 6.0. It draws all the bars in the same colour. I want to have each bar in different colour. I want bars of the same series to be so. There is only one series of data.
[Code]...
View 4 Replies
Nov 14, 2011
I 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 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
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 29, 2010
Are there any good free graph/chart dll's that anyone knows of?
View 5 Replies
Jan 5, 2011
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?
View 2 Replies
Nov 30, 2010
I 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 Replies
Mar 5, 2012
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]...
View 4 Replies
Aug 7, 2010
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 Replies
Jan 24, 2011
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?
View 2 Replies
Mar 23, 2010
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 Replies
Apr 6, 2009
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 Replies
Jul 4, 2011
Public Class Form1
Dim x As Integer, y As Integer
Dim img As Bitmap
Dim pixelColor As Color
Public Function getpixel(ByVal x As Integer, ByVal y As Integer) As Color End Function Private Sub find_img_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles find_img.Click
[Code]...
whenever i load the image, i have to load it a second time to get the colour, or if i load a new one, i get the colour from the previous image, any ideas as to why?
View 1 Replies
Nov 18, 2009
I've got a picturebox where someone can draw what they like on it and I have added a colordialog so the person can change the colour of the pen.[code]The trouble is, when I change the colour, the stuff ive already drawn on the picturebox changes colour too but I want it so that it only changes the colour of the pen and not what has already been drawn
View 3 Replies
May 26, 2012
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.
View 7 Replies
Jul 19, 2010
I have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
View 1 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
Apr 16, 2010
I've got a datatable with two columns "Status" (string) and "Total" (integer).
Status Total
Success 34
Missing 2
Failed 10
I want to databind this into a pie chart with each Status per slice but I'm not sure what method of data binder is required?
View 2 Replies
Jun 17, 2011
is there an easy way to stop the changing of colours when you disable a control. i want the controls to look normal just not do anything if you try to use them would have thought there is a global setting or something??
View 3 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
Sep 18, 2009
I can't figure out how to plot anything on this chart...finally got it to actually display a pie chart, now I'm trying to somehow bind a data source to it and from there, select the series data..I have added the database to the project as a data source but I don't know how to bind it to the pie chart. some other info: this db has 100's of tables and the program I'm working on is going to be a "status monitor" of sorts that will contain about 6-8 different types of charts all plotting different info for me in chart form.I want to bind this one data source to all the charts and just have them display different information (based on the sql query perhaps)
View 9 Replies
Dec 10, 2010
I'm using the chart control that's built in to Visual Basic 2010.NET Service Pack 4.
I am creating a basic date time graph with time on the axis and, at the minute, random points between -20 and positive 20 on the y axis. At the minute I can set everything up perfectly. The only problem is that the label on the x axis is not a time, it's a number. To be precise, it's the XLabelInterval value. This value is a double, so the label on the x axis is also a double not a time. But that's only interval I am setting. I think, by default, because I am not setting any labels, it is just using that value as the label as well.[code]...
View 8 Replies
Dec 24, 2010
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] .....
View 2 Replies
Apr 4, 2012
I 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 Replies
Mar 4, 2012
How do I plot multiple series (say about a thousand) on one chart at runtime?
View 7 Replies
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
Apr 22, 2009
I've created a two-worksheet template in Excel - the first sheet is for pretty charts, and the other sheet is for the data that drives those charts. I've written a vb.net 2005 app that can dump in all my data on the second worksheet, and the chart worksheet updates perfectly.I would like to do this report several times over in the same workbook. (So the tabs would read 'Person1 - Chart', 'Person1 - Data', 'Person2 - Chart', 'Person2 - Data', etc.)
My solution was to, for every person this report was going to be run for, copy the chart template, and then copy the data template. The problem is that every chart template that is created points to the original data worksheet. How can I set what worksheet each chart worksheet is pointing at?
View 3 Replies
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