i m building an application for my firm, needed to add a seating chart just like we do in an airline reservation etc, i need some ideas as to the direction i should take, the languages preferable etc.
View 8 RepliesI 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 want to know how i can make a random seating arrangement for 20 students in a class in which no student has the same seat number in vb.net.[code]i am having trouble with this part:Get the value for the set number at that location - that is where the student will sit.Remove the element from the list, using List.RemoveAt/Repeat while there are elements in the list.
View 3 RepliesI'm drawing my own charts based on values from a db. I'm drawing "directly" on the forms, so to speak. The thing is everytime the application is deactivated or if someting comes in front of the charts, the drawing dissappears. For instance, I have a contextmenu in one chart and whenever I use it there is a "hole" in the chart afterwards where the menu has been. Now I can see the reason for it, but how do I get around it?
View 2 RepliesI have to create a cafeteria survey application. Twenty students were asked to reate, on a scale of 1 to 10, the quality of the food in the student cafeteria, with 1 being "awful" and 10 being "excellent." Allow the user input to be entered using a ComboBox. Use an integer array to store the frequency of each rating. Display the frequencies as a bar chart in a list box.
I can get the comboBox and everthing, but it's not displaying the bar chart.
Here is my code.
Public Class Form1
'String array stores ratings
Dim ratings() As String = {"1-Awful", "2", "3", "4", "5", "6", "7", "8", "9", "10-Excellent"}
Dim studentCount As Integer 'number of student ratings entered
Dim frequency(9) As Integer
[CODE]...............................
I have been working on a UI app (written in VB.NET and using WPF) which creates charts using the Microsoft Chart Control for Windows Forms. The application retrieves data periodically from a remote database, parses and formats the data to create series, and then creates a chart based off the series which is then hosted in a WindowsFormsHost control. So far this process has been working well.
View 1 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 RepliesI have a stored procedure that takes in 2 parameters and returns an integer value. I would like this value to be the value for a gauge chart on the page. The 2 parameters will change depending on the attributes of the selected item. Is there a simple way to pass the one value from the stored procedure to the chart to display? This will be embedded in an asp.net application (vb) - so depending on the previously selected item, the values for the parameters and result will change.
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?
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 am working on an application that ties into a SQL database on the back end. Currently the main form contains a series of combo boxes (Graph type, data format, location, and customer), two date pickers, and a button to launch the selections in a new form. Everything works just fine except there are a couple of things I can't seem to accomplish.
Example Data:
[CODE]...........
Case Select (with commented out lines for variations attempted):
[CODE]..........
1) I would like to be able to use some sort of case statement to color the bars in my chart based on value. I have tried approaching this in a couple of different ways but neither of the options seem to work. First, I tried this (the If Not is used because depending on what values are passed to the stored procedure in SQL, different columns will be returned):
[CODE]..........
Only one series is created with this method, so I can see how/why a Select Case would set all bars the same color. I have also tried creating a series for each row in the returned dataset but it results in 22 bars of different colors, for each of the rows (484 bars):
[CODE]..........
So is there any way to modify the second set of code there to only select the value from the "Percent TMHB" cell that corresponds with Row(i), rather than ALL values from the "Percent TMHB" column for EACH Row(i)?
2) Since I am drawing/creating these graphs in a new window, is there any way to also create a new timer on the "newFrm" and have the tick refresh the data? I've struggled with this but I feel like it should be easy. Say someone chooses a "TMHB", "Percentage", "Chicago", "All" (Graph type, data format, location, customer) and launches the graph, which opens in a new window, then they want to do "TMHB", "Percentage", "LA", "All" and have both windows up, refreshing automatically throughout the day. Can I somehow store the SelectCommand.Parameters values in the new form/timer so that it will query the database again every 5 minutes?
Example code for the StoredProcedure and creating the new form:
If combo_GraphType.SelectedItem = "TMHB" Then
Dim newFrm As New Form
Dim newChart As New Chart
[CODE]..................
Got 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'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 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:
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 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.
how can i use the chart (vb 2010) in order to describe the information's in access database?
View 2 RepliesI'm using VB.NET 2008 and looking for MS CHART I don't think that I have this tool, where to get it please?
View 5 RepliesI've built an extremely useful page that inserts a chart using Office Web Components in ASP (VBScript).The chart looks great, the axes are labeled, background color is set, etc.
Now I want to add a logo image into the chart space. Is there a property for the chartspace object or some other way that I can overlay a small image into the corner of the chart space?
I'm in VB.NET 2008 and I'm using the chart control. I want to fix the range for the y-axis, though.
View 2 RepliesI am doing a bar chart project. my project should looks like this:
The problem i have right now is that i don't know how to draw the rectangle in the right way. my rectangle start to draw at the left top, how do i fix my code to make the rectangle draw start from the bottom? Also, i know how to draw string of my each input value, but i don't know how to print data values inside each bar, centered horizontally and vertically. This is what i have done so far
Here is my code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Blue As Brush = Brushes.Blue
Dim Red As Brush = Brushes.Red
[CODE].........................
How I can make 3D pie chart using VB code?
View 5 Repliesi have a Chart made in visual designer in vs2010, with some points added like x=3,8,10 Y=2,8,4. Is there any way to extract value for example for x=5 ?
View 2 Replies