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]...
I have an excel file that analizes the info on a SQL database. we have generated a few charts and now I want to be able to display them on a form in VB 2010I searched the web for info but the solutions I've found do not work and my guess is because they are for earlier versions of VB.I have been able to read or even write to the worksheet using this but on the graphvb.net
Dim oExcel As Object = CreateObject("Excel.Application")
Dim oBook As Object = oExcel.Workbooks.Open("C: est.xlsx")
Dim oSheet As Object = oBook.Worksheets(1)
[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 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 have a Windows form I would like to save the Ovals I created while running the form for use and review later I have been trying the SaveFileDialog but have not figured how to get my data out to the file that is created. I have read about using datatable but there again I'm working with that but need to find how to load all my Oval parameters into the table so I can recreate the current look of the form.
View 4 RepliesI'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[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 have used controls on a form to create a chart on the form. Now I want to print this chart to a printer. I have tried various approaches without much success and have searched the web etc for solutions but nothing gives the answer directly.[code]...
View 2 RepliesHow 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 ?
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 been able to make some dynamic pie charts. The pie charts are created on form load and are databind to a table. Now I would like to be able to click on the pie charts to open another windows form. I have searched a bit and every where they say to use the mouse down event.. the problem is that I am creating the pie chart with code and therefore when I use the:
View 4 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.
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 an application running on VS2010 and i'm using sql server 2008 r2. "Employee" table holds employees bio data, i can draw org chart using MS visio 2010 manual,i need to draw the org chart in Visio format from the VB.net application.
View 1 Repliesi want to create a chart in visual studio 2010 windows Form and i already research about on how to create chart in vb. I already created a simple chart but my problem is this;
1. How to create a chart in visual studio 2010 with databinding?
2. I need to make a query for instance;[code]when i input in a textbox.text lets say "user1" then the chart with a rate of 10 and time of 30 will be graph in my winforms.
3. Could i create a chart in crystal report?