C# - Make XY Scatter-type Plot Chart Using Asp.net Chart Control?
Jul 19, 2010I 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.
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.
I'm trying to plot a graph in VB.Net, using MS Chart Control. I'm receiving streaming data, distance vs X data (Sine wave) and Z data (Cosine wave) every 1 msec. maximum data points varies from 2000 to 5000. I would like to plot this streaming data on a graph, distance on x-axis and two series X data and Z data on Y axix.
View 3 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 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'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?
How do I plot multiple series (say about a thousand) on one chart at runtime?
View 7 RepliesI'm having problem with MS Chart chart type column. If there are only 9 bar in the chart like the following picture, then the axis-x label show up properly.
However, there are more than 9 bars bar the chart, the axis-x label wont show up properly, some of them just dissappear.
Here's my mark-up for the chart:
<asp:Chart ID="chtNBAChampionships" runat="server">
<Series>
<asp:Series Name="Championships" YValueType="Int32" Palette="Berry"
[Code]....
I don't know it works with only 9 bars? Is there any way to make the chart work properly? Also, if possible, how to make each bar have different color.
I'd like to use it to do some graphing. I'm trying to make MS Chart Control work, but all tutorials/code snippets that I've seen require ChartName.ChartData to populate the chart. When I enter this, I get the blue squiggly line of death:
Private Sub Form1_Load()
Dim array(1, 1) As Object
array(0, 0) =
[code]....
why this is happening? When I hold the mouse over Chart1.ChartData, I get the message "ChartData is not a member of System.Windows.Forms.DataVisualization.Charting.Chart".
I am using MS Chart control for VS 2008 and am attempting to bind a datasource without success. The provided samples show how to make candlestick charts with dummy data an how to bind x and y values with two fields.But how can I view OHLC stock data from a sql server table as a candlestick chart? The connection string and sql statement are working fine in other situations. The problem seems to be how I am binding the datasource to the chart. Here's my code:
Dim dataCmd As New SqlCommand
dataCmd.CommandType = CommandType.Text
dataCmd.CommandText = sSQL
[code].....
my only objective is to create a scatter plot with only x and y axes. the data source should be from a 1 dimensional array. say i have these arrays:
[Code]...
I can't figure out how to plot anything on this chart...finally got it to actually display a pie chart, now I'm trying to somehow bind a data source to it and from there, select the series data..I have added the database to the project as a data source but I don't know how to bind it to the pie chart. some other info: this db has 100's of tables and the program I'm working on is going to be a "status monitor" of sorts that will contain about 6-8 different types of charts all plotting different info for me in chart form.I want to bind this one data source to all the charts and just have them display different information (based on the sql query perhaps)
View 9 RepliesI'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
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 RepliesI 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 RepliesGot a chart control i wanna make from a data table. the table looks like this:
the chart i want will look like this:
'''
''''
[code].....
I have the smallest dataset in the world that simply consists of a month (text) and and amount. I want to produce a chart showing the month along the y-axis and the value up the x-axis. How do I do it? I have dragged the chart control onto the report page and populated the dataset. The chart shows but nothing like what I would expect. Just to make it simple I populated the dataset with an amount equivalent to the month number so it should show as 1 in January, 2 in Feb etc...However no matter where I drag the dataset's column names I don't get what I want. Where am I going wrong?
I use this simple loop to populate the dataset:
dsSales.Tables("Sales").Clear()
For i As Integer = 1 To 12
dsSales.Tables("Sales").Rows.Add(MonthName(i), i)
Next
ReportViewer1.RefreshReport()
I get this as a result:
How I can make 3D pie chart using VB code?
View 5 Repliesi want to make a thing were the user clicks a button and then a dragable little window shows with a line connected to the starting window. And when the user clicks a second button a third window appears with a line conected to the last created window. I saw it done once in a program created in C++ but i wonder if it can be done in VB.
View 3 Replieswhere can I get a bar chart control for visual basic.net and windows 7. Mschart.ocx doesn't work.
View 2 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 RepliesCan any one tell me how the chart control is used in .net framework 2.0 and it will be helpfull if you give any code
View 2 RepliesI can draw a graph with MS Chart Control 6.0 in VB.net. But I can not save it.I write the code:
AxMSchart1.copy() 'to copy the chart into clipboard
But whenever I use one of the flowwing commands: clipboard.GetData, Clipboard.GetDataObject,...I get the error: Exception of type 'System.ExecutionEngineException' was thrown?how to save the graph?
I've just started checking out Chart controls for VS .NET. I've downloaded and installed MS Chart Controls for .NET Framework 3.5 and ZedGraph.I'm trying to decide which would be my best choice. In VB6 I used RMCharts and liked it alot.
ZedGraph, like VS2005, is made to work with .NET Framework 2.0 and seems user friendly. Alot of my clients are still using XP machines without .Net Framework 3.5.
someone tell me where the chart control is in vs2005 .net framework is 2.0
View 2 RepliesWhat I'm trying to do is create an excel chart in a spreadsheet that I've just created using VB.Net code. I get the spreadsheet and chart created fine but then I get this error. An unhandled exception of type 'System.MissingMemberException' occurred in microsoft.visualbasic.dll. Additional information: Public member 'xlColumnClustered' on type 'Integer' not found. [Code]
View 1 Replies