Move A Charts Points In Excel?

May 5, 2009

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


ADVERTISEMENT

Asp.net - Microsoft .Net 4.0 Charts: Inconsistency With Points On The Same X-axis

May 24, 2012

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

View 1 Replies

Conditional Formatting For Excel Charts?

Mar 4, 2009

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 Replies

Creating Multiple Excel Charts With .net?

Feb 26, 2012

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

View 1 Replies

Functions To Draw Line Or Move To Points

Jul 19, 2009

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 Replies

Import Dynamic Charts From Excel In Forms?

Apr 14, 2010

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

View 1 Replies

Excel To Print Charts As PDFs With Image Artifacts?

May 15, 2009

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.

View 1 Replies

Create Excel Charts From MS Access 2007 Database Using Program?

Oct 20, 2010

I have a slight problem with something i am working on. I found this module here:

View 2 Replies

GDI: Make Drawn Object Move And Follow Path/Points At Constant Speed?

Nov 13, 2011

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

View 5 Replies

Offset The Points In A Polygon Without Having To Change Each One Individually The Points Are In An Array?

Apr 20, 2010

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 Replies

Move Some Text File To Excel?

Apr 16, 2010

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

View 2 Replies

Move To Datagridwiew To Excel Sheet?

Jul 18, 2011

I don't know, how to move to Datagridwiew to Excel sheet.

that not make Excel file, just showing Excel sheet.

View 1 Replies

Office Automation :: Move From One Excel Sheet To Another?

Jan 8, 2010

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

View 9 Replies

Office Automation :: Open And Move Around An Excel From VB 2008?

Apr 20, 2010

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

View 2 Replies

VS 2005 Move A Column And Hide Another In An Excel Worksheet

Sep 3, 2009

I am having trouble using VB .NET to move a column and hide another in an excel worksheet..[code]

View 2 Replies

Get The Points Which Make A Polygon From A Region Which Was Derived From The Polygon's Points?

Jan 31, 2010

how can i get the points which make a polygon from a region which was derived from the polygon's points?

View 1 Replies

How To Add Charts

Apr 1, 2010

How can we add charts in VB.Net?

View 1 Replies

Charts VB2008EE

Jun 29, 2010

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

How To Create Org Charts In .net

Mar 30, 2009

How to create org charts in vb.net?

View 6 Replies

Wrkin With MS CHarts?

Apr 15, 2012

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

Adding Series To Charts?

Sep 16, 2011

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

Create Charts Programmatic With Net?

Sep 10, 2009

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

Index Array Of Charts?

Apr 20, 2011

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

Spreadsheets And Charts In VB2010?

Apr 6, 2011

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

Website With Reports And Charts?

Jun 12, 2009

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

Winforms :: How To Create Charts

Apr 29, 2011

How to create Charts in vb.net. Is it possible to have a chart like this without any additional components

View 1 Replies

.net - Implementing MS Charts In ASP.NET MVC3 Project?

Nov 16, 2011

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

View 1 Replies

Adding A Dynamic Charts And Graphs?

May 11, 2011

i am working on a vb.net windows application. i want to incorporate the dynamic graphs and charts in the application.

View 1 Replies

Asp.net - Fusion Free Charts And Arraylist?

Feb 9, 2011

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

View 2 Replies

Button To Toggle Between Charts On A Form

Jun 22, 2010

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







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