One graph three variable?

The bubble chart requires 3 sets of data.
Once you create the chart on the range B7:I17 you can use the Source Data dialog to sort out the correct ranges for the X,Y and Size.

The labels are linked data labels from a dummy series.
Use this free addin to make the take easier
http://www.appspro.com/Utilities/ChartLabeler.htm

mate, why don't you post a data sample and see what we can come up with?

Kia ora

The swap the series around. Make the phones or periods the series and your variables responses one of the axes.

It would also help if you defined what you want from the charts when comparing all the data points.

I think Andy has pointed you in the right direction.

I've been playing with this and best (for readability) is to have the 9 categories on the X-axis and the phone types on the Y-axis.

I've you would use dynamic ranges you can switch between the months.

Make the first month yourself (and we'll help you with the dynamic ranges if necessary)

Originally Posted by teylyn

mate, why don't you post a data sample and see what we can come up with?

Kia ora

Hi mate due to ethical reason I can't post the data online.

Originally Posted by Andy Pope

The swap the series around. Make the phones or periods the series and your variables responses one of the axes.

It would also help if you defined what you want from the charts when comparing all the data points.

Hi Andy. You are right. But now let me explain how complicated the whole data is. Instead of male/female I have 9 categories. Instead of Sep, Oct and Nov I have 21 years (1 year at a point from 1989-2009). Instead of 3 phone types I have 19 age groups (0-18). As you can see I have 9, 21 and 19 categories in each variable.

Originally Posted by rwgrietveld

I think Andy has pointed you in the right direction.

I've been playing with this and best (for readability) is to have the 9 categories on the X-axis and the phone types on the Y-axis.

I've you would use dynamic ranges you can switch between the months.

Make the first month yourself (and we'll help you with the dynamic ranges if necessary)

Sorry i don't know what's dynamic range . . .

If you would like this dynamic range, then post a sample of your data like suggested (9 categories on the X-axis and the phone types on the Y-axis.)

We'll sort out the months for you.

Hi all this is the example I made up. There are 3 variables:

1. Age group -- 0-18 (19 categories)
2. Year -- 1989-2009 (21 categories)
3. Classification -- A-I (9 categories)

You can find 21 sheets in the workbook therefore if i want to present the data I need to flip between the charts. I am look into a solution that can combine all 21 charts together as a 3D graph (or something similar).

Thanks

Hi just wondering if anyone has taken a look at the file yet?

You don't say what it is you are trying to get from the chart.

If you have a time series why not plot lines. Each line is a Age group. You can construct a panel chart were each panel is a Classification.

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

jayesh84, Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Welcome, slenoisto the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

PeterGGG: This forum can be pretty strict about not posting your question in an old thread. I would suggest that you start your own thread. If you feel that this thread will be useful to us in helping formulate a response, you can include a link to this thread.

In this specific case, I would also suggest that you frame your question in terms of how much is Excel and how much is generic charting question. It seems that a lot of this thread (and perhaps your question as well) is more generic "what kind of chart or charts will be good for this kind of data" rather than more Excel specific "how do I create a scatter chart in Excel". As many responders here tried to ask the OP, include what you are really trying to visualize and/or communicate with these charts, as that will impact the type of chart chosen and the data plotted on that chart.