Jon,
If all you want to do is create a cube positioned to show three faces,
with each face showing a picture of a table, then it is possible but painful.
Notice I said that each cube face shows a picture of a table. The user
cannot enter or alter the table data. I don' know of any method to create an
interactive data cube within any of the office program suite.
== To create display cube ==
You would need to create a cube consisting of one autoshape for each of the
three exposed cube faces. The fill for the autoshape would be a picture of
your tables.
The tables could be created in word, excel or powerpoint. You would have to
copy the table and then paste special to create a picture of your table. You
have to create a picture of the table because a tables cannot be rotated
using office. (table text can be rotated rotated +/- 90 degrees, but the
table row/col structure cannot be rotated). Some picture formats within
office can be rotated (spun clockwise or ccw on the flat surface of the
screen). Office doesnt directly allow pictures to rotate into the depth of
the screen.
Also, you will need a graphics program to alter the shape of the table
pictures so that the table picture is skewed to match the angles of the
autoshape.
If you want an interactive 3d data structure it might be possible to create
this structure within excel. A few years ago there was a spreadsheet program
that advocated a cubic data structure. The program never sold very well, as
it was freak.
The idea of this software package, was that the user could create a very
complex structure such that when viewed from face 1, the data represented a
one Data reporting format; when viewed from face 2 ,the data represented data
and report format 2; when viewed from face 3 D&R format 3, etc. Of course any
structural change (add a col, delete a row) rippled across all faces and d&r
formats. The result was chaos.
It is easier to create and manage a flat data structure of multiple tables
(spreadsheets) using excel or even access. Access is one of several programs
to allow relational data structures.
--
Tom Conrad
===
"Jon" wrote:
> The idea is that I create a cube that includes three dimensions of 'text'
> displayed across the cube, say:
>
> 1st dimension - Business Area 1 (reports to / liaises with)
> 2nd dimension - Business Area 2 (receives report / communication)
> 3rd dimension - Purpose of communication
>
> "Jon" wrote:
>
> > I'd like to create a 3d table, is this possible with MS Word or Excel?
|
Similar Threads
