Pictures are nice, but trying to get a 3D conceptual object into a flat
picture is difficult, especially if you want people to understand it.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"GStolz" wrote in message
...
Thank you!
This is a good suggestion, but I think the people I'm working with really
want a picture. I'll try the information in another post in this chain,
first. If that doesn't work - I'll take this route.
- Gail

"Jon Peltier" wrote:

I actually had imagined a transparent Rubik's cube. While this sounds
like a
nice visualization, it would be hard to create and hard to interpret.

How about a structure like an org chart? The first row below the main
node
has one node per program, the row below that has one node per population
connected to each program, and the row below that has a node for each
collaboration focus connected to each node in the row above. Then enter a
value under the last row of nodes. You could rearrange which factors are
split out in which row.

That's not very interactive, though. This way is more so:

Put the data into four columns:
Column 1 - program name
Column 2 - populations of interest
Column 3 - collaboration focus
Column 4 - value of interest

Make a pivot table. The value of interest goes into the Data area, and
the
three other factors can be placed into the Rows and Columns areas, and
moved
around until you get an arrangement that illustrates your information.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"GStolz" wrote in message
...
Sorry to be confusing -
The result I'm interested in would be something like a transparent
Rubik's
cube. It's to display a concept, not the results of a data analysis.
Axis 1 - program name
Axis 2 - populations of interest
Axis 3 - collaboration focus
Each cell could contain yes/no information, or a percentage, or some
other
proxy. If I could get the chart going, I expect I'd quickly understand
what
the cell contents need to be for it to look the way I hope it will.
Thanks for your help!

"Jon Peltier" wrote:

Three categorical axes? If you had three categories on each axis, the
result
would just be a grid, like Rubik's cube. Think about what you want to
show,
then post back with a more detailed description.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"GStolz" wrote in message
...
I would like to create a 3-axis chart using Excel 2007, with each
axis
displaying categorical information. Although I am fairly familiar
with
the
chart options in 2003, I'm new to 2007 and I haven't attempted a
3-axis
chart
before.

I realize that 3-axis charts are not usually recommended, but I
think -
in
this particular case - it might be exactly what we need.

How do I do it? What kind of table to I need to construct for Excel
to
be
able to graph the data?

Thanks!