Bubble Chart Problem

[#1]

Hi Everyone,

I need to have bubble chart in such a way that for a paticular Quater, it displays the volume of three different Markets. But these Markets should be displayed in different places  for a particular market but not in one line. I m attaching the snapshot, plz have a look. Here the Bubbles are Markets. Thank u.

[Anonymous]

on what basis do you want the dots to align.. you need to have a metric on which you can assign the location of the dots..

[#3]

Basically I have Quarter  and Market as Dimensions and Volume as Metric..............

[Anonymous]

Hi Kumar,

Please provide some sample data.

[#5]

Hi rathodnikhy,

Here is the sample data,

it is below just scroll it down............

MARKET	QUARTER	VOL
R	Q1	250
D	Q2	146
G	Q3	215
G	Q4	138
R	Q1	208
D	Q2	237
R	Q3	193
D	Q4	276
G	Q1	203
G	Q2	290
R	Q3	154
D	Q4	121
R	Q1	271
D	Q2	142
G	Q3	163
G	Q4	196
R	Q1	131
D	Q2	216
R	Q3	130
D	Q4	165

SPECIALTY	QUARTER	VOL
R	Q1	250
D	Q2	146
G	Q3	215
G	Q4	138
R	Q1	208
D	Q2	237
R	Q3	193
D	Q4	276
G	Q1	203
G	Q2	290
R	Q3	154
D	Q4	121
R	Q1	271
D	Q2	142
G	Q3	163
G	Q4	196
R	Q1	131
D	Q2	216
R	Q3	130
D	Q4	165