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 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'm trying to delete a number of records in a table from the last and forward. My idea is to use sql like this: delete top " & variable & " * from table where ID = something It gives me a general sytax error. Is it at all possible? Fuga. Edit: I also have the order by statement there. I just forgot to put it in the question.
View 5 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 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]....
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]...
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]...
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?
I have a program that creates a excel spreadsheet and a chart on each tab from extracted data in various .txt files. Before the chart is created, two of the excel columns will end up with data like this: on column 9 and 10. I also use data (time, looks like 09:15) in column 11 that shows the time at the bottom of the chart. There are just too many digits in the output and the readability looks bad so I can also convert.
Input Output
800400047320000
825400047120000
[code]....
The chart will display those values just fine but, normally the conversion in code that I do during the placement of that data (so it reads a bit better) looks like this:
'Convert bit to Kbit
If InRate.Length < 7 Then
InRate = CDbl(InRate) / 1000 & " Kbit"
[code]....
how to make the chart work with just numbers and ignore the MB or Kbit at the end?
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 RepliesI 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