3-axis charts

G

GStolz

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!
 
G

GStolz

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!
 
J

Jon Peltier

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 
G

GStolz

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

x-axis scaling 2
charts look different if you put in data into the x axis 3
Combination Chart 1
Remove the weekends from a pivot chart x axis 0
Changing scale on horizontal axis... 1
Bizarre chart behaviour when changing axis cross at points 2
Chart - Missing Text on Vertical Axis 1
Secondary Axis 1

Top