Probably a silly question but is it possible in Excel or VB to drag a charts point(s) ?I had a quick look at the object "Points"(part of Series Collection object) methods and saw there was a "Select" function.
View 4 Replies
I'm creating a Chart using the .net 4.0 System.Web.UI.DataVisualisation library and have noticed an odd behaviour.
First I'm creating a Series with two datapoints, each with the same value on the X-axis, as follows:
Dim series As New Series()
series.Points.Add(New DataPoint(0, 10))
series.Points.Add(New DataPoint(0, 15))
[Code]....
Then, the chart still only renders two points on the X-axis (0 and 1), and the first two values (on x-Axis value 0) are connected vertically!
Anyone know why this behaviour is different? Either behaviour would be acceptable really, but I'd like to be able to choose one of them...
Is there a way to conditionally format an Excel Chart? For example I have a bar graph. Currently I have the bars a purple color. I would like to turn a certain bar red if it meets certain criteria. Is there anyway to do this?
View 1 RepliesI'm trying to create multiple Excel charts, in one work sheet using VB.net.This is the code:
Code:
'creating the chart
Dim chartPage As Excel.Chart
Dim xlPump1Charts As Excel.ChartObjects
[code]....
Currently there are functions to draw line or move to points, commonly known as LineTo(x,y) of MoveTo(x,y). I am wondering if there is also a LineTO or MoveTo function(s) for 3D, i.e. LineTo(x,y,z) or MoveTo(x,y,z).
View 1 RepliesI am using VB for developing a GUI. I need to display charts in the VB form. How do I invoke Excel 2003 using VB and import the charts created in it.
Steps:
1) Getting input from the user using VB form and processing it in VB or external application such as Matlab.
2) Over-Write the processed data in excel sheet.
3) Modify the charts based on the new data which I believe will happen automatically.
4) Display the chart in the VB form.
I have an Excel 2007 workbook chock full o' VBA macros that do various things, including one that jumps from chart to chart making PDFs of each using PDFCreator, based on some code I borrowed from Ken Puls (url...).However recently I and some users of the workbook started having problems where the PDFs would be created with either gray image artifacts over the charts,or the whole chart image would have a double of itself skewed slightly. It just happens the problems started after we did a global upgrade to Office 2007, though I had had 2007 installed on my computer for a while and tested and used the workbook extensively without issue up until then. Here is the part of the code that automates the printing:
Sub PDF_print_all()
'Author : Ken Puls (www.excelguru.ca)
'Macro Purpose: Print to PDF file using PDFCreator[code]...
The problem is not consistent either... sometimes it will print to PDF with an oddly shaped block of gray, and sometimes it will only have the whole chart image doubled. The only consistency I could find is that sometimes if an object is selected in a chart beforehand (a text box, chart line, axis numbers, etc) the gray artifact will partly mimic the shape of whatever object had been selected.I wish I could include example images to show exactly what's happening.I know it's not a problem inherent to PDFCreator because if I manually print to it in Excel, the PDF image looks perfect. It's only when I use the automated method that the problem occurs, so I thought maybe it was the code.
I have a slight problem with something i am working on. I found this module here:
View 2 RepliesI've come across a very basic problem which I'm sure has a basic answer.Forgive me but I haven't programmed in years and this just a hobby of mine..My problem is that I need a drawn object (say an ellipse) to move to the cursors location when I click. Imagine an adventure quest style game where you view your character in birds eye view, and it moves according to where you click on the map.I can draw the image fine, and move the image around fine - it's more so the formula I'm using which I'm a little stumped on.I have certain requirements though.
1. I need a timer that constantly updates the drawn object's (lets say character from now on) location. Each tick will essentially be the character taking 1 step towards the cursor's location.2. At the end of each tick of the timer, it'll will invalidate the form/control to invoke the paint event, and of course, the objects location will be be updated.It sounded simple enough to create a linear equation based on the objects original location and the location of the cursor when I click.However, that will not give it a fixed speed.If say for example, the gradient (rise/run) between the cursor location and objects location is very steep, the object's y-velocity will be greater than that of the x-velocity
is there a way to offset the points in a polygon without having to change each one individually the points are in an array
View 2 RepliesI am using a vb.net to move some of the data of the .txt files to excel template. my problem is after it has been transfered. all rows of the A cell only will have automatically enable the wraptext. if I set the wraptext to false, all of my data will be lost.
the text files look like something as this:
TEST, DATA1, DATA2, DATA3,
T1 , 01, 02, 03,
T2 , 02, 34.05, 1.04,
So when this data be moved to the excel template: The TEST columns will all have the wraptext enabled. Can anyone adviced me on how to prevent this? Below is my code to read and transfer the data.
objReader = New StreamReader("D:wynnz
eoMTFdimm2.txt")
_readArrayLine = Split(objReader.ReadToEnd(), cComma)
[Code]...
I don't know, how to move to Datagridwiew to Excel sheet.
that not make Excel file, just showing Excel sheet.
I am trying to move from one Excel sheet to another in VB.Net 2008.
My code is as follows:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Dim oXL As Excel.Application
[Code].....
I'm trying to open an excel file and then move around a little bit in the excel from VB 2008 and I having some problems. I'm trying next:
dim objExcel as excel.application
objExce = new excel.application
objExcel.visible=true
[code]......
I am having trouble using VB .NET to move a column and hide another in an excel worksheet..[code]
View 2 Replieshow can i get the points which make a polygon from a region which was derived from the polygon's points?
View 1 RepliesHow can we add charts in VB.Net?
View 1 Repliessetting up a Bar chart and a Pie chart... The Barchart repsent how many people have that and the piechart is how much of what that person has bought.. i need to be able to change that?
View 2 RepliesHow to create org charts in vb.net?
View 6 Repliescurrently i m workin on Ms CHarts wid VB.NET nd create a chart sucessfully bt nw i wnt to click on that particular bar of that chart nd want to get that particular axis label of that bar ..
View 2 RepliesI am new to Visual 2010 and cannot seem to find any information about using Charts.I have an array, call it PressureOutputs(1000), which I wish to plot against a second array,e(1000).Can anyone please explain how I would add these two arrays to create a series on an x-y scatter graph (which is already present on the Windows Form Application), or point me to a source of information about how to do this?
View 2 RepliesI'm trying to get my head around excel charts. I've poured over these posts for the last couple of days now and i'm coming up dry. I've got a xl file thats got some data in the first 2 columns. I want to put the data in an XY scatter plot. Column A is the x coordinates and b is the Y.[code]...
View 6 RepliesUnder VB2 I could create a form with many charts (One form had 12 graphs). You could define the chart once and cut and paste it the required number of times on the form. Each chart had an index and the code used the index to create and update the desired chart with the appropriate x,y data. Is it possible to do this in VB2010?
View 5 RepliesMy project that I had built used spreadsheets and charts within the forms to provide the user with the necessary data. This worked fine for VB2008 as it had all of the ActiveX office web components built into it. It seems that VB2010 has a different set of base components and emphasis office 14.0. I was wondering how people have gotten around this or if they can. I tried using DataGridView, but it doesn't seem to be able to do what I want to do. I need the ability to have users enter data into a table and then use that information to be able to build graphs real-time based on their data.
View 2 RepliesI am writing an ASP.Net VB2005 application, and I want to give my users the ability to create custom reports and charts on the fly, based on parameters defined in a wizard control. The data source is SQL 2008. This is also on my own dime, so I am looking for something that will not require a second mortgage.
View 2 RepliesHow to create Charts in vb.net. Is it possible to have a chart like this without any additional components
View 1 RepliesI have a MVC application, which creates a Chart in the business logic like this:
StatisticsModel.Chart.Width = 150
StatisticsModel.Chart.Height = 300
StatisticsModel.Chart.Attributes.Add("align", "left")
StatisticsModel.Chart.Titles.Add("Statistics for: " + StatisticsModel.ProductNumbers)
StatisticsModel.Chart.ChartAreas.Add(New ChartArea)
[Code]...
i am working on a vb.net windows application. i want to incorporate the dynamic graphs and charts in the application.
View 1 Repliesi am trying to use an arraylist to build a graph using fusionfree however i cant get it to work, it keeps showing the same item from the array list
[code]...
I have a form with two seperate charts placed on top of each other.I am trying to set up a toggle button that works in sequence i.e. loads second graph over first on click. When clicked the second time it loads the first one and so on.I realise i can do this by making one visible then making it not visible but i am having troubles with the circular click requirement.
View 3 Replies
