3-D XYZ Axis Chart for Presentation ?
Discussion
Can any guru's please advise if it's possible using Excel or another app to create a 3-D X,Y,Z 3 axis graph ?
In other words
X - Virtical axis
Y - Horizontal axis
Z - front to back axis
Like an area map, but using bars to plot the data
bit like this image:
In other words
X - Virtical axis
Y - Horizontal axis
Z - front to back axis
Like an area map, but using bars to plot the data
bit like this image:
Edited by Shadytree on Thursday 14th February 14:41
Excel can certainly do this.
Create a data table like this (based broadly on your example)
A B C D E
1 Jan-Feb Mar-Apr May-June etc
2 2001 $200 300 500
3 2002 fill in data here
4 2003
5 2004
Highlight the entire data range, so above it would be A1..E5, for example.
Click Chart Wizard Icon on toolbar (or Insert, Chart if no icon showing).
Choose column as the type, then on the right hand side of the window select 3-D Column as the sub-type.
Follow the rest of the wizard to tart it up as necessary.
Simon
ETA - My data table formatting went away when I posted, hope you can understand it.
If you PM me your email I'll send you a sample spreadsheet with graph.
Create a data table like this (based broadly on your example)
A B C D E
1 Jan-Feb Mar-Apr May-June etc
2 2001 $200 300 500
3 2002 fill in data here
4 2003
5 2004
Highlight the entire data range, so above it would be A1..E5, for example.
Click Chart Wizard Icon on toolbar (or Insert, Chart if no icon showing).
Choose column as the type, then on the right hand side of the window select 3-D Column as the sub-type.
Follow the rest of the wizard to tart it up as necessary.
Simon
ETA - My data table formatting went away when I posted, hope you can understand it.
If you PM me your email I'll send you a sample spreadsheet with graph.
Edited by sgrimshaw on Thursday 14th February 17:43
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff