I am trying to draw a graph in X, Y, Z axis but cant get throught, I was sucessful in drawing in two axis X,Y can any one help me in this.
I am trying to draw a graph in X, Y, Z axis but cant get throught, I was sucessful in drawing in two axis X,Y can any one help me in this.
Andy Pope offers this approach as well: http://www.**--****.com/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://www.**--****.com/ _______
1.How do I prepare a comparitive analysis graph in Excel
2.create a 3 dimension axis graph
I would like to create a three axiss, three dimension graph that I can use in powerpoint.
Hi all, Is it possible to exactly size a graph for example from A5:G30?? and not having to visually try to come as possible to the end of a cell and so on? thanks
4.Combining Single Dimension to Multi Dimension Array
I haven't seen this anywhere. I'd like to combine a group of single arrays to a multi-dimension. The item array(s) have 5 characteristics (e.g. A,B,C,D,E). I'd like to make a new product family array that consists of all the item arrays (e.g. A,B,C,D,E F,G,H,I,E A,G,H,J,K) Then I could use the product family array as a look up table to extract info. I'd like to get away from creating a worksheet to store the info, since it would only be temporary. Also, since new items are introduced every 6 months I can just add a new single item array, and then rebuild the product array. Any ideas? TIA, SK
5.Array transfer - 1 dimension v. 2 dimension
The following sub is supposed to read in column A and transfer to D, then read in columns B and C and transfer to E and F. In the first transfer, the value in A1 is transfered to all of column D, in the second transfer B and C transfer correctly to E and F. Does anybody know why the 2D transfer works, but the 1 dimension transfer doesn't? Sub foo() Dim lastRow As Long Dim i As Integer, j As Integer Dim myRange() lastRow = Cells(65536, 1).End(xlUp).Row ReDim myRange(1 To lastRow) For i = 1 To lastRow myRange(i) = Cells(i, 1).Value Next i Range(Cells(1, 4), Cells(lastRow, 4)) = myRange lastRow = Cells(65536, 2).End(xlUp).Row ReDim myRange(1 To lastRow, 1 To 2) For i = 1 To lastRow For j = 1 To 2 myRange(i, j) = Cells(i, j + 1).Value Next j Next i Range(Cells(1, 5), Cells(lastRow, 6)) = myRange End Sub Regards, John Wolf
6. GRAPH exported to EXCEL ARE NOT EXCEL GRAPH
Users browsing this forum: No registered users and 20 guest