Does anyone know of a way to do this:
in excel?
Surface chart seems to be the only useful chart to represent 3D data…
R
Select 3D Column as the chart type.
What version of Excel are you using?
What is your data and how is it organized?
Just an FYI - while a 3D chart like that looks pretty, it’s absolutely worthless in delivering any sort of information accurately. Go with a 2D clustered column chart.
http://info.emeraldinsight.com/research/img/clustered_column.gif
What Munch Said…
3D column is just pretty looking 2D data. I need the columns behind each other like Real! 3D
I use 2007, but I’d appreciate a solution in any version!
It shouldn’t really matter what my data is, but if it makes things simple, lets say this is my data:
Cars sold by color in 2005:
Red 5
Blue 6
White 2
in 2006:
Red 6
Blue 7
White 10
Now I need color along x axis, year along z axis and the height of columns corresponding to number sold along the y axis.
This and pivot tables are what I currently use. But I have some data sets that are really large, I end up with so many columns, they’re just lines. plus the 3D way is actually a better way to represent 3D data. you can see trends in say - only the third column type.
Surface charts do exactly what I want except its continuous, my data isn’t meant to be.
Ooof. I managed to get it looking correct for the data you gave, but it didn’t involve anything that was intuitive, or easily used with larger data sets. I’m really surprised that 2007 doesn’t do this easily.
Once you select the chart type (under the “Insert” tab), click on the chart, and go to “Select Data” up top. From there, you’re going to have to fiddle - I honestly can’t recreate what I did.
Screenshot?
I am confused. I answered this.
Here is an example using your car data.
http://www.seiglefamily.com/data/3Dbarchart.xlsx
Select the data. Insert chart. Select Column. Select 3D. Select the rightmost icon showing three axes.
:smack:
Yes you have. Now how’d I miss that. looks stupid
Thanks!