#1   Report Post  
Posted to microsoft.public.word.docmanagement
jon jon is offline
external usenet poster
 
Posts: 66
Default cube

I'd like to create a 3d table, is this possible with MS Word or Excel?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Tom Conrad Tom Conrad is offline
external usenet poster
 
Posts: 88
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
jon jon is offline
external usenet poster
 
Posts: 66
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Tom Conrad Tom Conrad is offline
external usenet poster
 
Posts: 88
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cube root symbols Grammar Check problem Microsoft Word Help 3 May 3rd 23 02:47 AM
how do i write square and cube in word vanessa Microsoft Word Help 2 September 29th 06 03:00 AM


All times are GMT +1. The time now is 09:45 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"