Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
cube
I'd like to create a 3d table, is this possible with MS Word or Excel?
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
cube
What do you mean by 3d?
Do you want this table to be user interactive or do you merely want a display trick? Using multiple Excel spreadsheets provides data layering. In that the user can choose to manipulate data in all cells A1 across several sheets. An excel user can create named ranges, and use formulas to manipulate data across several sheets. For example the formula for cell Sheet1!B2 could be =(sheet1!A1+sheet2!A1+sheet3!A1) -- Tom Conrad "Jon" wrote: I'd like to create a 3d table, is this possible with MS Word or Excel? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
cube
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? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
cube
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cube root symbols | Microsoft Word Help | |||
how do i write square and cube in word | Microsoft Word Help |