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.

3 posts
• Page **1** of **1**

- pocket pc
- pocket pc
- WINDOWS SERVER
- lisp
- scanner
- dotnet framework
- automation
- MS OFFICE OUTLOOK
- windows ce
- MS OFFICE OUTLOOK

- 1. How to do a dynamic plot in Excel via VBA?

Hi I want to write a code in VBA in which a dynamic set of rows ( the number of columns is fixed to 4) in excel are to be read and a plot type: " xlXYScatterSmooth" Could someone help me figure out how to write this one? thanks - 2. How to add different error bars to each data point in excel

I am busy writing a thesis and am plotting some data using the clustered column graph. I have 5 values on the X-axis (time in days...0-4), and for each of these X-axis values (days) I have 3 Y-values (high, medium, low dose observations). The problem is that each Y-axis value is a mean, and has a unique standard error of the mean (SEM). However, I can't find a way to make unique error bars for each data point. Instead, it will only allow me to enter 1 custom error bar value per dose observation over time. I feel like this is doable, but I just can't figure it out. Perhaps I just need to use another graph format? I feel like there is something really obvious that I am missing... I don't know if this is clear, but was wondering if anyone can help. I really don't want to have to draw these error bars in using powerpoint. I can elaborate if need be... Thanks in advance! - 3. How can I graph quadratic or quartic equations

I want to know how can I graph equations from linear equations to quartic or higher degree equations using excel charts utility? - 4. Scales - Excel 2007 beta

How can I change the scales of my data range. For example, in my data range I have the year 1970 through to 2006, but office in all its WISDOM has started it at 1965 and ended it at 2010. This used to be such an easy thing to change. It is pathetic that Microsoft would make this such a headache. - 5. Excel 2000 - Pie Chart # of slices

Is there a limit to the number of slices in an Excel 2000 pie chart. I can only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete.

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

3 posts
• Page **1** of **1**

Users browsing this forum: No registered users and 20 guest