how to prepare 3 dimension graph in excel



  • 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

Postby U29tIENoYXR0ZXJqZWU » Fri, 10 Dec 2004 00:23:03 GMT

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

Postby Barb Reinhardt » Fri, 10 Dec 2004 00:41:22 GMT

This might help.


Re: how to prepare 3 dimension graph in excel

Postby Jon Peltier » Fri, 10 Dec 2004 03:16:23 GMT

Andy Pope offers this approach as well:


- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

Similar Threads:

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 

3.Graph dimensions

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?


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 
(e.g. A,B,C,D,E
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 
Any ideas?

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

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

John Wolf


7. how to prepare payroll in excel

8. preparing report for export to Excel

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 20 guest