The ultimate graph problem!

[k.r.goddard]

I am trying, and failing, to get a graph to show what I want. I need a 3D area graph for several train services to show their load factors by station, with station along the bottom and passengers on the z axis. I have got this far. However I also need to show capacity and when trains go over this capacity. What I had planned on doing is a 3D area which is stacked so shows up a different colour when load exceeds 300 for example. This is possible to do for one train service on a graph however I want several train services on one graph, basically 8 stacked area graphs on one axis. I tried setting up several different graphs and then pasting them but they stack up on top of one another rather than side by side.

Any help or tips is much appreciated. I know it will be very fiddiliy but it does not need to be easily editable e.g. once it has been done it will just be dropped into a word document as an image.

Thanks,

Kyle

 

[Sal Paradise]

There aren't that many 3D charts in Excel (only 2 that I know of -- Bubble Charts and Surface Charts). I don't know what you want your graph to look like, but I made a Surface Chart with the following data and it looked like something:

Excel Workbook
	A	B	C
1	Station	Capacity	Passengers
2	Kawaramachi	300	377
3	Karasuma	300	65
4	Omiya	300	183
5	Saiin	300	453
6	Katsura	300	320
7	Nagaoka Tenjin	300	381
8	Takatsuki	300	414
9	Ibaraki	300	380
10	Awaji	300	100
11	Juso	300	86
12	Umeda	300	214
Sheet1

 

[shemayisroel]

For any charting requirements, try looking at the below

http://peltiertech.com/Excel/Charts/index.html

http://www.andypope.info/charts.htm

Hope some of that helps.