Excel 2007

Posted on 2012-09-14
Last Modified: 2012-09-15
I am trying to design a mattrix for shelving, so that I could easily locate where a certain item is on a particular shelve, rack and the place in the rack.
So if I have a 4 foot shelve, x 2 feet deep and 2 feet high.
And if each box is 6 inches square (for ease of this problem),this would mean
I could 8 boxes placed on the horizontal shelve that is 4 feet long.
+ 3 more boxes (the first box is counted as the horizontal) behind the first box of 6 inches, and 3 more boxes stacked high (as the height is 2 feet)
I would like to tabulate a 3-D type of table, so that I would know which box is placed where.
Eg. : If had marked boxes B1 thru B9
then B1 will occupy the first spot on the horizontal line of 4 feet.
B2 will occupy the spot behind B1, and
B3 will occupy the spot on the top of B1.
Is there a way of drawing a 3-D table to give me an effect like what I have in mind.  
Thank u.
Question by:jegajothy
    LVL 19

    Accepted Solution

    Other than Charts.... Excel doesn't offer a solution for a 3d Axis (that I am aware of).

    Can you break your problem up in to 3 distinct 2 dimensional representations instead?

    for example...

    on one "row" for a shelf... you have 8 boxes wide, 3 boxes tall.  (a 8x3 grid)

    is it acceptable to just represent this with three 8x3 grids to accomodate the entire "depth" of the shelf?

    Author Comment

    In response to buttersk, u mentioned Charts.  Hope u can elaborate with a sample of how it is done.
    It will be ideal to have the depth too, all in one.  Your 8x3 gives me an idea, but would u be able to implement the depth too.  Even a chart too will work, as it is just to record the locations for physical identification.  Thank u.
    LVL 19

    Expert Comment

    by:Ken Butters
    I just meant charts is the only "3d" style of representation in excel... but it is not really is just a 3d representation of a 2 axis or 2 dimensional set of data.

    like when you have a bar chart... but the bars are represented in 3d...  that does not give you the capability to implement another axis that would include depth.

    Author Closing Comment

    Excellent suggestion.  thank u

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    Average across mutiple sheets 5 31
    MS Excel Cell questions 5 39
    Excel line breaks 1 19
    Excel 2010 question 3 23
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now