VS 2010 Delete Chart Borderline?

Mar 6, 2012

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

View 2 Replies


ADVERTISEMENT

VSTO - Excel Chart, Subtitle For Chart - Access Chart Text Box From Code?

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

VS 2010 Delete Top 1 - Delete A Number Of Records In A Table From The Last And Forward?

Mar 16, 2011

I'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 Replies

C# - MS Chart Customize Value Label And Draw Line Series Across The Chart Area

Aug 25, 2010

I'd like to get suggestion in both C# and VB.NET I created Chart like the following image:

[Code]....

View 1 Replies

C# - Make XY Scatter-type Plot Chart Using Asp.net Chart Control?

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

Graph - Chart Axes - Connect The Data From The Array And Use It On The Chart

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

VS 2008 Making Chart Form Txt File With Ms Chart Tool?

Mar 23, 2009

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].....

View 6 Replies

Dynamically Add And/or Remove Chart Series From WinForm Chart?

Mar 23, 2012

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 Replies

Print Data Chart The Resolution Of The Chart Changed

Feb 17, 2012

When i'm tryed to print Data chart the resolution of the chart changed as shown:

View 3 Replies

Chart Object In VB 2010?

Feb 16, 2010

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 Replies

How Use MS Chart Control With VS 2010

Dec 21, 2009

How 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 Replies

VB Chart In 2010 Express?

Oct 22, 2011

Im 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 Replies

VS 2010 - VB Chart Controls ?

Oct 6, 2011

I'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 ?

View 3 Replies

VS 2010 Bar Chart With Looping?

Mar 2, 2011

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]....

View 14 Replies

Chart Object Not Working In VB 2010?

Dec 28, 2010

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]...

View 7 Replies

Populating A Chart In VB 2010 Professional

Mar 7, 2011

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.

View 5 Replies

VS 2010 Copy A Chart To Another Form?

Mar 10, 2011

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]...

View 1 Replies

VS 2010 Dynamic Line Chart?

Aug 28, 2011

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 Replies

VS 2010 Reset A Chart Programmatically?

Dec 2, 2011

I'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 ?

View 2 Replies

VS 2010, .NET: Enable Chart Wizard?

Nov 28, 2011

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 Replies

[2010] Create An X-Y Scatter Chart?

Jul 29, 2010

I 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!

View 2 Replies

ASP:Chart Control - Databind Pie Chart From Datatable

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

Microsoft Chart Controls Runtime Chart?

Nov 5, 2010

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 Replies

MS Chart AxMSChart1 - Getting Chart To Display Labels

Jul 4, 2009

I 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 Replies

Pie Chart And Bar Chart Using .net Of Visual Studio 2005?

Apr 21, 2010

i 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 Replies

Draw Org Chart Using MS Visio 2010 Manual?

Apr 26, 2012

i 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 Replies

Visual Studio 2010 Chart Databinding

Feb 15, 2012

i 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?

View 1 Replies

VS 2010 .NET Excel Chart Cell Formatting?

Dec 1, 2011

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?

View 2 Replies

VS 2010 / 20 Or More Series In A Single Chart Area

Apr 2, 2012

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 Replies

VS 2010 : Line Graph With Chart Control?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved