Clustered Column with a Z axis?

[geff]

I have no idea how to create the chart I'm after.

I have attached my spreadsheet. On the Data page you can see a summary of questions that have been answered at courses on 2 seperate days. I have created a chart for the day of the 03/04/2007 within the workbook but I would like the data for 16/01/2007 to be behind it in the same format...if that makes sense. So I need to somehow create a Z-axis with date range across it.

Any help would be greatly appreciated.

[geff]

Can anyone help?

[noblecat]

I think you are probably trying to put too much data on one chart and it will be hard to read.

Two suggestions both of which use the 3-D column column subchart type (bottom left hand column of the chart type selector). This chart type allows comparison across categories and series. Note, under 3-d view options for the chart, I prefer to use the right angle axis option.

Option one: Create a chart that shows the responses for a single question for both days. Make a new chart for each question and then stack them in a single page. The attached example shows this started for the 1st 2 questions.

Option two: Create a chart that shows the responses for all questions for a single day. You could then stack the two different days. However, because of the number of questions, the "deeper" series often get lost, so this one is harder to read in my opinion.

Good luck