Excel - Code In VBA And Recording A Macro - Input A Values For The X Axis Rotation And The Y Axis Rotation
Sep 16, 2009
I am having some major problems with the code in VBA and recording a macro didn't get me anywhere nor is the VBA help file. I have to have it so that I can input a values for the x axis rotation and the y axis rotation so that my 3d surface graph will rotate whatever values I input, the 3d surface graph will rotate those degrees. I also have to have a method for having the default rotation. I was also wondering how to put scroll bars for the x and y rotation. The only other thing I am having trouble with is having an input to check box for right angle axes. So far I have two cells for entering the x rotation value and the y rotation value. I also already have my 3d surface graph.
View 3 Replies
ADVERTISEMENT
Jan 29, 2011
I have created some 3d models(VB) for display in a WPF 3d Viewport and would like to rotate them. I would like to rotate them about an axis of rotation defined by a line through two 3d points. All the examples seem to rotate about one of X Y or Z axes and are not helpful for a more general approach. The angle of rotation is easily found. My maths is a bit rusty now so is there a function that would calculate the axis easily ?
View 2 Replies
May 22, 2012
I have a P/L chart which has a left scale (Y axis) which starts from a negative value. I want to format the axis labels (the major tick mark labels) so that the negative ones are red.
Something like;
If cht.ChartAreas(chtarea).AxisX.MajorTickMark.Value < 0 Then
cht.ChartAreas(chtarea).AxisY.LabelStyle.Font = New Font("Verdana", 9.0F, FontStyle.Bold, Color.Red)
[Code]....
Of course that doesn't work since MajorTickMark doesn't have a value property. How does one make this work?
View 1 Replies
Aug 14, 2011
I am having trouble in getting the coordinates of x-axis and y-axis in low level ouse hook...all I am getting is values in x-axis listbox and in y-axis listbox I am getting zeros......why? and my second problem is I am calling the setcursorpos
function in a for loop because I want to automate mouse movements and clicks, but setcursorpos function is not working , maybe because I am getting the coordinates wrong.....here is my code
low level mouse hook
Public Class MouseAutomating
Inherits HotKey
Public lstbox As New ListBox
[code]...
View 4 Replies
Jan 8, 2009
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:
View 1 Replies
Jul 27, 2009
I have 2 columns of data B and C.i want to set the data under column B as x-axis and C as y-axis correspondingly to plot a x-y graph.[code]...
View 1 Replies
Nov 9, 2010
I have successfully created excel application, workbook, worksheet and graphs in excel through vb.net, but I am not able to choose which data to plot on teh x-axis when I plot graphs.I don't really know how to do this even in excel itself, and googling did not help at all...how to create a graph with desired values on the x axis in excel through vb.net, that would be nice.
range1 = Data.Range("A1", "B" & (t2 - t1) / i)
graph1.SetSourceData(Source:=range1)
This is my code, since I have index (t2-t1)/i as the index of the data I want to plot on the y-axis, and I want to plot all A1 values on the x-axis.
View 2 Replies
Oct 28, 2009
I am working on simple handover process from one mobile station to other. I got three proposed results service disruption time, network entry time, connection set up time. I also have the result of these three as by using some conventional way and got improved these three delay results by proposed way. Results are store in textboxes. Now i want to show graphically. E.g. I want to show conventional service disruption time on x axis and proposed service disruption time on y axis or vice versa. Let suppose I want to have a scale on axes from 1 to 3000 milliseconds. Then I want to show how purposed scheme is better. I am using VB.Net 2008.I have created chart. I also studied MS chart for windows forms samples environment. Also applied different chart properties like titles, series and others, But I am not able to make x and y axes scales. How to get values on the axes and how to generate graph? [code]
A chart element with the name '0' could not be found in the 'ChartAreaCollection'.i also tried using ChartAreas(Default") but i am getting same idea.I don't get what for this chartAreas value in parenthesis is used.
View 1 Replies
Dec 16, 2011
In my vb.net project, I use zedgraph to draw figures. I find that the following properties work well to zoom figure on the center of mouse.
[Code]...
View 2 Replies
Jul 22, 2009
I have used MSChart control and created line graph. when i move my mouse over the graph, i want to display X-axis value and Y-axis value in another label above the graph.
View 2 Replies
Mar 3, 2010
I'm importing some data from MySQL into a VB.NET application with .NET charts. At the moment, the chart is plotting points by date, which means that when you zoom in, each major tick mark simply displays the date.It would be better to change these dates to times (hours) when one zooms in.Presumably there's a parameter to do this, but I can't find it.
View 1 Replies
Dec 26, 2009
explain how Graphics.RotateTransform is working?
[Code]...
View 6 Replies
May 19, 2009
I'm developing a sun shading analysis tool, and part of the analysis involves rotating a house (modelled as a cube consisting of 8 points) by the solar azimuth and solar altitude angles. The reason for this is to determine if the wall in question is facing the sun, and if so I run a shading analysis using a scanline algorithm to determine the percentage of wall plane that is in shade from a tree in the yard (this is modeled using overlapping 2D polygons). The purpose of the rotation and tilt of the object is so that the wall plane is directly perpendicular to the sun, so that the analysis can be done in 2D as opposed to 3D.
I first rotate each point of the house (which is stored in an array) through the azimuth, and then tilt it up through the solar altitude angle. I have set up my 3D coordinate system using the standard right-hand rule for orientation of the x,y,z axes. I'm using a basic rotation matrix as follows:For the azimuth, I am rotating around the z-axis, so I am using the following matrix transformation.
[x',y'] = [x*cos(azimuth) - y*sin(azimuth) , x*sin(azimuth) + y cos(azimuth)]For the altitude, I am rotating the object about the x-axis to tilt it up. I use the initial z-coordinate and the transformed y'-coordinate for the altitude tilt calculation.Each point, when completely rotated and tilted, will have a distinct set of coordinates: [x', y'', z'].Individually, the rotation and tilt work fine. But when I try to do them consecutively, I run into problems.
View 4 Replies
May 3, 2012
I am first time working on PDF documents.I was searching on Rotation of a PDF page. I got some code samples regarding rotations by 90,180,270,360 degrees.
But my problem is that if there is a very small rotation required of the order of few degrees .. Is there any way that we can specify an angle using a slider bar or use the mouse to click and rotate the PDF page...
View 3 Replies
Apr 1, 2011
I have a screen full of puzzle peices they are all rotated at different angles (90,180,270). is there a way to track the peices rotation? I was thinking of using a 2d array to store there rotation. however, I am using this code to rotate the peices:
[Code]...
View 6 Replies
Jan 24, 2010
i'm developing a simple 2d animation program. my task is to get the center point of a rotation, for example: at the frame 0 there is a rectangle at x,y coordinates and with 0° of rotation at the frame 10 there is the same rectangle, translated and rotated what is the center point around which the rotation occurred? This is not really a question about programming, i know, rather than a problem of geometry.
View 1 Replies
May 12, 2012
how to rotate image like 3d rotation?
View 2 Replies
Jun 27, 2012
I looked at several questions/answers posted already such as this one on a planar polygon but could not find one that explains results in 3D such as the one shown in this paper and this one on "point cloud skeletonization through Laplacian-Based Contraction" where this quadratic equation comes back in both.
View 1 Replies
Jun 13, 2012
my question is regarding working out the direction of the smallest angle between two vectors in 2D. I am making a game in C++ where one of the obstacles is a heat seeking missile launcher. I have it working by calculating the vector between the target and bullet, normalising the vector and then multiplying it by its speed. However, I am now coming back to this class to make it better. Instead of instantly locking onto the player I want it to only do so only when the bullets vector is within a certain angle (the angle between the bullets vector and the vector bulletloc->target). Otherwise I want it to slowly pan towards the target by a degrees thus giving the player enough space to avoid it. I have done all this (in a vb.net project so i could simplify the problem, work it out then re write in in C++). However the bullet always rotates clockwise towards the target even if the quickest route would be counter clockwise. So the problem is working out the direction to apply the rotation in so the smallest angle is covered. Here is my code so you can try and see what I am describing:
Function Rotate(ByVal a As Double, ByVal tp As Point, ByVal cp As Point, ByVal cv As Point)
'params a = angle, tp = target point, cp = current point, cv = current vector of bullet'
[Code]...
I had was to work out the bearing of the two vectors and if the difference is greater than 180 degrees, rotate clockwise otherwise rotate counter clockwise
View 1 Replies
Mar 12, 2011
SI like doing random things like 3D objects inside a windows form. With that said, I'm creating an application that will, eventually, write the code for me, after I do it myself visually.If you run the app it will make some more sense I guess.Now, to rotate the cubes, I'm using
.Transform.World = Matrix.RotationYawPitchRoll(CSng(CubeRx(1) / 10), CSng(-CubeRy(1) / 10), CSng(CubeRz(1) / 10))
now I do not want the world to rotate, just my individual cubes.Here's an example of me referring to my cube in action
If howmanycubes >= 1 Then
' vb2 = New VertexBuffer(GetType(CustomVertex.PositionNormalColored), 36, d, Usage.Dynamic And Usage.WriteOnly, CustomVertex.PositionColored.Format, Pool.Default)
[code]....
how to apply textures to the cube.instructions:When running the program, type in values on right side and click create cube.before you click create cube again, those same text boxes will adjust your current cube.Then when you click create new, it places another cube ontop of your current cube, so you'll need to give it new values.Not much validation is going on so some bad values will cause crashes.
View 1 Replies
Jun 4, 2009
What I need to do is query an iTextSharp AcroField to check if it is rotated, and if so capture the value of the rotation.So If I have the following field:
Dim af As iTextSharp.text.pdf.AcroFields = stamper.AcroFields
Dim afi As iTextSharp.text.pdf.AcroFields.Item
afi = af.GetFieldItem("fieldName")
What do I need to do to get the rotation (in degrees) of that specific field?
View 1 Replies
May 31, 2010
I'm trying to build a dial control as a custom user control in VB.NET. I'm using VS2008.so far I have managed to rotate image using graphics.rotatetransform . however, this rotate everything. Now I have a Bitmap for the dial which should stay stable and another Bitmap for the needle which I need to rotate.so far i've tried this:
Dim gL As Graphics = Graphics.FromImage(bmpLongNeedle)
gL.TranslateTransform(bmpLongNeedle.Width / 2, bmpLongNeedle.Height * 0.74)
gL.RotateTransform(angleLongNeedle)[code].....
As I understand it, the image of the needle should be rotated at angle "angleLongNeedle" although i'm placing the rotated image at 0,0. However, the result is that the Needle doesn't get drawn on the control.
View 2 Replies
Sep 12, 2011
I have 2 consecutive images from a camera and I want to estimate the change in camera pose:
I calculate the optical flow:
Const MAXFEATURES As Integer = 100
imgA = New Image(Of [Structure].Bgr, Byte)("pic1.bmp")
imgB = New Image(Of [Structure].Bgr, Byte)("pic2.bmp")
grayA = imgA.Convert(Of Gray, Byte)()
[Code]...
How do I calculate the new position and lookat?
If I'm doing this all wrong or if there's a better method,
View 1 Replies
Sep 1, 2009
How to find shift and rotation between same two images using programming languages vb.net or C++ or C#?
View 5 Replies
Sep 1, 2011
I am using API calls to transform a Bitmap object. I have various physical transformations (rotation, flipping, scaling, displacement) as well as some colour adjustments (inversion, brightness and contrast)Everything works fine except for when I use the rotation or shear transformations in combination with the colour adjustment. In that case the colours revert to the original image.The interesting thing about this problem is that it seems to be dependent on the off-diagonal factors (eM12 and eM21 below) in the XForm matrix. For example, here is the rotation matrix:
Public Sub RotateClockwise(Radians As Single)
With XFormMatrix
.eM11 = Cos(Radians)[code]....
is there some way I can use both SetWorldTransform and SetColorAdjustment when using non-zero values for the off-diagonal factors in my XForm transformation?
View 1 Replies
Oct 4, 2008
I am developing a game in compact framework. In Mobile Devices there is a button that Rotates the screen by 90 degrees so you can hold the mobile device the way that suits you. The problem is that i want to handle that in my game, so if i see that the screen has rotated the game will pause.
[Code]...
View 2 Replies
Nov 9, 2010
I can do this using VBA, but I want to be able to create the code using a compiled VB programme, which can then be opened in Excel.
View 1 Replies
May 13, 2011
I am using the MSChart object in VB2010. Live futures data is put into an array, then added one point at a time to a line chart (Chart1, one line only) using (1):
frmChart2.Chart1.Series("data").Points.AddXY(sec10, spreadarray(0, sec10))
All fine and good. However, by the time a few thousand data points have come through, its getting hard to see the detail in the chart, therefore I reset the x-axis so that I just see the last 200 (say) points, using (2):
Chart1.ChartAreas("ChartArea1").AxisX.Minimum = frmPrices.sec10 - CLng(lstChartpts.Text)
...where frmPrices.sec10 is the total number of data points, and CLng(lstChartpts.Text) is the number of points required. So if I have 1000 pts, and I wish to see 200 displayed, the AxisX minimum in this case is 1000 - 200 = 800. Points then start to build again one at a time. I am happy with this except that the Y-axis scaling is still taking into consideration all 1000 data values, so need to reset the Yaxis maximum and minimum. No problem (3):
Chart1.ChartAreas("ChartArea1").AxisY.Maximum = (max of the last 200 values + a small increment)
Chart1.ChartAreas("ChartArea1").AxisY.Minimum = (min of the last 200 values - a small increment)
The problem comes in when I want to change the number of points to display back to "ALL". I could re-write the code to use the max and min of all values, as in (3), but I'd rather just reset the yaxis back to the autoscaling that the chart started out with. I've looked everywhere for a property or method to do this! Or is there a way to autoscale the yaxis according to only the displayed values?
View 8 Replies
Nov 2, 2009
Ok, so I am attempting to try my hand in directinput, I got the code up and running within VB.net, it recognizes the controller and almost all buttons work, but for some reason 2 or 3 of the axis do not work on each controller.I have tried this with an xbox360 wireless controller and a Logitech wired controller (ps2 style) they both show the correct amount of axis on each controller, but do not work correctly.[code]I have looked everywhere for my problem, but the issue is, I am not exactly sure what the problem is to search for.if anyone also knows how to access the "X" (power) button on the xbox controller, that would be awesome as well, because I want it to interact with my program!and if you don't have a wireless receiver a wired one is exactly the same...
View 2 Replies
Dec 20, 2009
I would like to display the word " Volts(V) " in the Y axis, just like the one you see from the attached image. But that image is crop from elsewhere and placed into a picturebox, which to me, doesnt look nice. I would prefer if the words are type in manually into a label and then rotate.
I did some research through the forums and websites, and came across this: [URL]
from there, i have a brief idea on it , tried out but it didnt work though. Or i may not have done it correctly.
View 8 Replies
