[Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel 2007

Posted on 2012-09-14
Medium Priority
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
  • 2
  • 2
LVL 19

Accepted Solution

Ken Butters earned 2000 total points
ID: 38399132
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

ID: 38399832
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
ID: 38399962
I just meant charts is the only "3d" style of representation in excel... but it is not really 3D...it 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

ID: 38401695
Excellent suggestion.  thank u

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

868 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