## how to prepare 3 dimension graph in excel

MS EXCEL

### Next

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

### how to prepare 3 dimension graph in excel

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

```

### Re: how to prepare 3 dimension graph in excel

```This might help.

http://www.**--****.com/

```

### Re: how to prepare 3 dimension graph in excel

```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/
_______

```

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

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

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