A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

cube



 
 
Thread Tools Display Modes
  #1  
Old August 15th 07, 10:52 PM posted to microsoft.public.word.docmanagement
jon
external usenet poster
 
Posts: 66
Default cube

I'd like to create a 3d table, is this possible with MS Word or Excel?
Ads
  #2  
Old August 16th 07, 12:52 AM posted to microsoft.public.word.docmanagement
Tom Conrad
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  
Old August 17th 07, 01:56 AM posted to microsoft.public.word.docmanagement
jon
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  
Old August 17th 07, 02:30 AM posted to microsoft.public.word.docmanagement
Tom Conrad
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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i write square and cube in word vanessa Microsoft Word Help 2 September 29th 06 03:00 AM
Cube root symbols Grammar Check problem Microsoft Word Help 2 December 7th 05 04:51 PM


All times are GMT +1. The time now is 03:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.