The 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]...
Where 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 RepliesBasically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them.
When I create the charts, I use Sheet1.Controls.AddChart(...), which returns a Microsoft.Office.Tools.Excel.Chart with which I can handle events and such. However, when I reopen the file and look through the Sheet1.Controls collection, there are no Chart objects. Accessing the charts through Sheet1.ChartObjects.Chart gives me Interop Charts, when I need the Tools Charts.
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 asp.net chart intervel issue. I am feed data to chart like below
X1 Y1 X2 Y2
100 907 500 2395
100 745 500 2343
100 760 500 2403
Each row is a series in the chart.
In am iterating each row in code and making new serie and adding to chart
series1.Points.AddXY(dt.Rows(i)(0).ToString, dt.Rows(i)(1).ToString)
series1.Points.AddXY(dt.Rows(i)(2).ToString, dt.Rows(i)(3).ToString)
Chart is coming like it is fine. Now I want make interval like 100,200,300,400, 500 (500 is max of the graph). I tried Chart1.ChartAreas(0).AxisX.Interval = 100, It did not worked out.
How do I link data in an Excel spreadsheet to a chart object in Visual Basic 2010? Really basic here, I just want to draw a single simple line chart from a single column of data. Is it easier just to read the data into an array (which I can do) and somehow get it into the chart?
View 1 RepliesI am new to this forum - and while I have programmed in VB.Net for some time, I am also new to Office Automation - so please bear with me We are creating a Metrics presentation in Powerpoint 2003.Currently, the presentation is manually created. We are automating this through VB.Net. I figured out how to add the slides from the template. I can modify text boxes and other objects other than the MS Chart objects. I can modify MS Chart objects - but find that after updating the chart, saving it, and closing the application - it apparently doesn't save correctly. When I reopen the presentation, it originally shows up with the changed data. Once I double-click it, however, it doesn't keep the modified data.
I looked at the properties of the graph in VB.Net - and it looks like the chart shape is read-only. I thought of two solutions - one: copy the chart, modify a local copy, and paste it over the original, or two: make the read-only chart writable. Problem is - I'm at a loss for how to complete both of these.As far as the copying of the chart, I found some information about using the .Copy() command, so I cam up with the code
[Code]...
How do I access the new attributes of Excel 2007 chart objects from VBA code such as setting the line gradient on a data series?
View 1 RepliesHow do I link data in an Excel spreadsheet to a chart object in Visual Basic 2010? Really basic here....I just want to draw a single simple line chart from a single column of data. Is it easier just to read the data into an array (which I can do) and somehow get it into the chart?
View 1 RepliesI'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 RepliesI have an object (ClassGPS) containing a DataTable that is exposed through the property "Satellites". My form has a bindingsource that, upon load, associates itself to a new ClassGPS object. The table has 5 columns, two of which ("PRN" and "dB") I want to chart using the new 4.0 chart tool. So the chart object's DataSource = ClassGPSBindingSource, and the DataMember = Satellites. That is all set in the designer.In ClassGPS.New(), the table is pre-loaded with 4 rows. This object is created before the form loads. When the form loads and the bindingsource is set to the created GPS object, the chart correctly updates and displays the four pre-loaded entries.On this form, I have a button that adds more entries. Tracing from the Click event, pushing the button does add the entries properly to the underlying table, and if I create a ListCHanged handler on the data source, the events are all correctly firing, but the Chart does not update to reflect the changes.
So to test, I added a Datagridview object. Just like the chart, I set its datasource to ClassGPSBindingSource, and the DataMember to Satellites. And here's where it gets weird. In the designer, the newly added DataGridView control has 4 columns in it labeled RowVersion, Row, IsNew, and IsEdit. I didn't create these columns, it does it itself. If I try to change the bindings on these columns to reflect the actual datatable names (PRN and dB) two things can happen:
1) If I hit Play (F5) to debug the program, the DataGridView looks and acts correctly inside the program and is correctly bound and updating fine as I add new data. In the designer underneath however, the changed columns have disappeared and are replaced with the original four it is creating for no apparent reason. When the debug session terminates, the columns - which just finished functioning fine in the debug session - are now gone.
2) If I hit Build, the designer destroys my columns immediately and recreates those it defaulted to.In either case, something very fishy is going on... in that the Chart, with the exact same binding settings as the datagridview, does not work but the datagridview works just fine (unless Build is hit prior to Run).Has anyone run across this? Can you reproduce it? I have bound a chart to a datatable before and it worked just fine, but it didn't have to update except when the form it was on was closed and later re-loaded.
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 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'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].....
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 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 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?