Basically, the user will input a "product" into a textbox and upon a button click, will be transferred to a listbox. The problem that I have is that I need to also collect a precentage for each product, and using that percentage, create a type of bar chart with "x"s based on the percentage. The final outcome of the application should look something like this-
[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 RepliesI'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
What I have to do is to search the whole system for any Mp3 files.My Problem is to loop through all the subfolders.What I managed to do:
Imports System.IO
Imports System.Runtime.InteropServices
Public Class Form1
[code]....
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.
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]...
I'm trying this example but it doesn't seem to work. It gives a IndexOutOfRangeException:I'm using a txt file where the columns are Tab seperated.)
Imports System.Windows.Forms.DataVisualization.Charting
Imports System.Data
Imports System.Data.OleDb
[code].....
I did a quick net search and found this which works great for looping through all the buttons to disable them. These buttons are located right on the form.
For Each ctlControl In Form_BLAH.Controls
Select Case TypeName(ctlControl)
Case "Button"
ctlControl.Enabled = False
End Select
Next ctlControl
However...when I tried it on a form where the buttons are contained within a Table Layout Panel it does not work.
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 RepliesWhen i'm tryed to print Data chart the resolution of the chart changed as shown:
View 3 RepliesWhere can I get more information on the "chart" object that appears to be new to VB 2010. It does not show up in the VB documentation and the parameters of its use are a bit vague when you look at the details of the module implementation.
View 1 RepliesHow use MS chart control with VS 2010?What name reference link I need add to project for use MS chart.I don't see MS chart control in "Toolbox" in VS 2010, what I need do for I will see MS chart control in "Toolbox".If any body can send me link to simple sample "use MS chart in VS 2010".
View 1 RepliesIm trying to make a chart where the bottom values in time in 15 min increments and the vertical values are $ figures from a database table of time stamped sales.I have no idea how to make this happen, cant even get the time to appear at the bottom.
View 4 RepliesI'm currently working on a WinForms project using .NET v3.5 due to limitations imposed by a 3rd party API that I have to use.
For the project I have to include some graphs however I've no budget (surprise, surprise) to purchase 3rd party controls & the graph controls within .NET v3.5 dont have that elusive "wow" factor that I'm looking for.
The chart controls in .NET v4 (MS version of the Dundas controls) are just what I'm looking for but I unfortunately cant use them as the 3rd party API won't work in v4 & there are no plans to have it upgraded to v4 compatable anytime soon
Does anyone have a pointer to any good (& free) chart controls that I could use ?
Okay, so basically I'm trying to have my application randomly select items from a (multiselect) listbox. I want the user to enter the amount of items they would like randomly selected and it should all happen at the same time. I have the random shuffle down but it only selects one song each time you click the button. How can I loop this code as many times as the user specifies in the textbox?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
Dim shuffle As New Random
Main.songlist.SelectedIndex = shuffle.Next(0, Main.songlist.Items.Count - 1)
[code].....
I started a thread about playing music. It works perfectly, but I wanted to know if there is a way for the song to be looped. I'm making an alarm clock, and if the user chose a short song, it plays once and then stops. I just wanted to know if there was a way to loop using the mciSendString.
View 9 RepliesThe following code worked fine in MS Office 2007 PowerPoint Macro.However, in 2010 it crashes at the line "For each cht in..Function CopySheetChart(Sheet As Excel.Worksheet, Row As Integer, Col As Integer, _
Workbookname As String) As Boolean
' Copy the Excel sheet that has top left copy to RowOffset from the page header, and column Col
Dim Cht As Excel.ChartObject
[Code]...
I would like to enquire how I would go about population a chart (bar graph) in VB 2010 Professional?
I am pulling the information from a MS SQL Database.
I would like to copy a chart to another form. I have a MainForm which displays several charts. However I have another form which I would like to copy some of the graphs from MainForm to this new form (GraphCompare) so that the charts can be compared easily by the user. I am unsure on how to do the actual copying part.
so far I have this:
Dim Chart56 As New Chart
Chart56 = Chart1
GraphCompare.Panel1.Controls.Add(Chart56)
[Code]...
This is the code in VBA
ActiveSheet.Shapes("Chart 1").Line.Visible = msoFalse
This is VB.net for ChartArea and PlotArea
chart.ChartArea.Border.ColorIndex = False
chart.PlotArea.Border.ColorIndex = False
I cannot delete the chart's border
I know how to do a simple graph on VS.I have a value in a textbox wich is updated every second and I need the chart to display that value on the chart every second with the last 5 values or so.
View 3 RepliesI've a chart control on a windows form & am using the following code to populate it :-
' Create a data series
Dim series1 As New Series()
Dim series2 As New Series()
[Code]....
The data to populate the chart is supplied by the user & then the above code is actioned from a button click event.
I am looking for the user to be able to change the data that is inputted & re-run the graph, so my question is - how do I create a new instance of the chart each time the button is clicked ?
I am using VS 2010, VB.NET and when I drag a chart object to my form from the toolbox, no wizard appears. Do I need to enable wizards in VS 2010? or is there another reason the wizard doesn't automatically appear?
View 2 RepliesI am trying to create an X-Y Scatter chart from VB and it just refuses to come out right. I have two columns of data, with headers. If I manually grab say A1 to B100, Insert chart, X-Y scatter with straight lines, it works fine. Basically, column A is Elapsed Time, and B is data. So it plots B on the graph and the X-axis is the elapsed time, one series.If I automate from VB, I can't get the same affect. Either I get two series or the X-axis is just numbers 1 to n When I highlight the series in Excel, this is what the formula bar says when it's correct:
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$100,Sheet1!$B$2:$B$100,1)
When it's close, but wrong:
=SERIES(Sheet1!$B$1,,Sheet1!$B$2:$B$100,1) close, need A range between commas
I've tried two methods:
xlRange = xlWorkSheet.Range("B1")
xlRange = xlRange.Resize(ArraySize + 1, 1)
xlChart = xlWorkBook.Charts.Add()
[code]....
I just can't seem to get it right!
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?
I am using microsoft chart controls in VB.net. The graph data currently comes from my database, but all the series and chart formats were made before runtime. I want to know how to make charts on runtime, being able to select the x axis from my dataset and multiple y columns from my dataset.
View 1 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 Repliesi wish to create line chart, pie chart and bar chart using vb.net of visual studio 2005.Second question is i wish to copy a few data into datagridview from microsoft office tools such as access or excel using shortcut key 'ctrl+C' and 'ctrl+V'.code to do the 2 functions above without installing additional tools?
View 5 RepliesI have a code which adds each line of a textfile to a List(Of String).I have around 1.5 million entries in the textfile. It adds it to the list in like 1 second. However, I'm trying to add all the users to a threadpool to do a certain function. So I try:
For i as integer = 0 to list.count - 1
The list has like 1.5 million entries so the GUI freezes untill it all finishes in like 5 minutes. How can I make it go faster and not freeze the GUI?
I'm trying to login to the mobile login page for hotmail.com. I want to login to each account, I have them in a multi-line textbox1 in username : password format (no-spaces) on new lines. It loops through all the accounts before the page is even loaded. and when the page has loaded, it logs into the hotmail login from the last login details at the end of the textbox, instead of going from first to last. It's not clicking submit button either, its just showing the username and password looping in the inputs. Not submitting at all. The submit button code is right. I know it works. So thats not the problem.
Here is my [URL]