Thread: 3-axis charts
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GStolz GStolz is offline
external usenet poster
 
Posts: 3
Default 3-axis charts

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!