Placing bubbles

I would like to place bubbles on the 2D places (x,y) with different radius.
The coordinates are the (column, row) an´d the rtadius the value in the cell
(column, row). For example the value 0.25 in the cell (2,5) means, that a
bubble with radius 0.25 placed on the 2D coordinate system at the location
x=2, y=5.

How to do it ? The bubble chart places the bubbles on the location (column,
radius).

Thanks in advance, Laszlo

I'm probably not understanding but I'll take a shot . . . assuming the bubble
chart is similar to an XY Scatter chart, wouldn't you set your data up like
this:

x y size
2 5 0.25
4 6 0.46
6 8 0.68
9 6 0.96

The coordinates as you've presented them looked like they might be swapped.
Can you post back with an example similar to that above of how your data is
set up?

----
Regards,
John Mansfield
http://www.pdbook.com

"laszlo" wrote:

> I would like to place bubbles on the 2D places (x,y) with different radius.
> The coordinates are the (column, row) an´d the rtadius the value in the cell
> (column, row). For example the value 0.25 in the cell (2,5) means, that a
> bubble with radius 0.25 placed on the 2D coordinate system at the location
> x=2, y=5.
>
> How to do it ? The bubble chart places the bubbles on the location (column,
> radius).
>
> Thanks in advance, Laszlo

Dear John,

thanks a lot for your fast answer !

If I translate my date to your example, it will work, as desired.

But my data are placed as follows (I'll use your example):

I have a range of 10 rows / 10 columns: A1:J10. The cell A10 represents the
coordinates (X=1;Y=1); the cell B10 represents the coordinates (X=2;Y=1), the
cell A9 represents the coordinates (X=1, Y=2) and so on. For example the
cell C6 represents the coordinates (X=3;Y=5).

Back to your example:

B6 = 0.25
D5 = 0.46
F3 = 0.68
I5 = 0.96

Is there any symple way (e.g. without transforming my 10 X 10 range into the
proposed 3 x 100 range) to create the desired chart ?

Thank you in advance,

Laszlo

"John Mansfield" wrote:

> I'm probably not understanding but I'll take a shot . . . assuming the bubble
> chart is similar to an XY Scatter chart, wouldn't you set your data up like
> this:
>
> x y size
> 2 5 0.25
> 4 6 0.46
> 6 8 0.68
> 9 6 0.96
>
> The coordinates as you've presented them looked like they might be swapped.
> Can you post back with an example similar to that above of how your data is
> set up?
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
> "laszlo" wrote:
>
> > I would like to place bubbles on the 2D places (x,y) with different radius.
> > The coordinates are the (column, row) an´d the rtadius the value in the cell
> > (column, row). For example the value 0.25 in the cell (2,5) means, that a
> > bubble with radius 0.25 placed on the 2D coordinate system at the location
> > x=2, y=5.
> >
> > How to do it ? The bubble chart places the bubbles on the location (column,
> > radius).
> >
> > Thanks in advance, Laszlo

Laszlo -

Why not just rearrange rearrange your data? Any charting requires that
the data be appropriately set up in the first place.

In another sheet, set up a new range. Put X, Y, and Size into A1:C1. In
A2 enter this formula:

=INT((ROW()+8)/10)

In B2 enter this formula:

=MOD(ROW()-2,10)+1

In C2 enter this formula

=INDEX(Sheet1!$A$1:$J$10,11-A2,B2)

where Sheet1 is the sheet with your original data. Fill this down to row
101, and use this range for your bubble chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

laszlo wrote:

> Dear John,
>
> thanks a lot for your fast answer !
>
> If I translate my date to your example, it will work, as desired.
>
> But my data are placed as follows (I'll use your example):
>
> I have a range of 10 rows / 10 columns: A1:J10. The cell A10 represents the
> coordinates (X=1;Y=1); the cell B10 represents the coordinates (X=2;Y=1), the
> cell A9 represents the coordinates (X=1, Y=2) and so on. For example the
> cell C6 represents the coordinates (X=3;Y=5).
>
> Back to your example:
>
> B6 = 0.25
> D5 = 0.46
> F3 = 0.68
> I5 = 0.96
>
> Is there any symple way (e.g. without transforming my 10 X 10 range into the
> proposed 3 x 100 range) to create the desired chart ?
>
> Thank you in advance,
>
> Laszlo
>
> "John Mansfield" wrote:
>
>
>>I'm probably not understanding but I'll take a shot . . . assuming the bubble
>>chart is similar to an XY Scatter chart, wouldn't you set your data up like
>>this:
>>
>>x y size
>>2 5 0.25
>>4 6 0.46
>>6 8 0.68
>>9 6 0.96
>>
>>The coordinates as you've presented them looked like they might be swapped.
>>Can you post back with an example similar to that above of how your data is
>>set up?
>>
>>----
>>Regards,
>>John Mansfield
>>http://www.pdbook.com
>>
>>"laszlo" wrote:
>>
>>
>>>I would like to place bubbles on the 2D places (x,y) with different radius.
>>>The coordinates are the (column, row) an´d the rtadius the value in the cell
>>>(column, row). For example the value 0.25 in the cell (2,5) means, that a
>>>bubble with radius 0.25 placed on the 2D coordinate system at the location
>>>x=2, y=5.
>>>
>>>How to do it ? The bubble chart places the bubbles on the location (column,
>>>radius).
>>>
>>>Thanks in advance, Laszlo

Hi Jon,

thanks for explanation and for transforming proposal. If there is the only
way, I will reaarrange every time my area (the dimension is variable - today
10 x 10, tommorrow perhaps 15 x 15).

Thank you for your response and for your help.

Warm regards,
Laszlo

"Jon Peltier" wrote:

> Laszlo -
>
> Why not just rearrange rearrange your data? Any charting requires that
> the data be appropriately set up in the first place.
>
> In another sheet, set up a new range. Put X, Y, and Size into A1:C1. In
> A2 enter this formula:
>
> =INT((ROW()+8)/10)
>
> In B2 enter this formula:
>
> =MOD(ROW()-2,10)+1
>
> In C2 enter this formula
>
> =INDEX(Sheet1!$A$1:$J$10,11-A2,B2)
>
> where Sheet1 is the sheet with your original data. Fill this down to row
> 101, and use this range for your bubble chart.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> laszlo wrote:
>
> > Dear John,
> >
> > thanks a lot for your fast answer !
> >
> > If I translate my date to your example, it will work, as desired.
> >
> > But my data are placed as follows (I'll use your example):
> >
> > I have a range of 10 rows / 10 columns: A1:J10. The cell A10 represents the
> > coordinates (X=1;Y=1); the cell B10 represents the coordinates (X=2;Y=1), the
> > cell A9 represents the coordinates (X=1, Y=2) and so on. For example the
> > cell C6 represents the coordinates (X=3;Y=5).
> >
> > Back to your example:
> >
> > B6 = 0.25
> > D5 = 0.46
> > F3 = 0.68
> > I5 = 0.96
> >
> > Is there any symple way (e.g. without transforming my 10 X 10 range into the
> > proposed 3 x 100 range) to create the desired chart ?
> >
> > Thank you in advance,
> >
> > Laszlo
> >
> > "John Mansfield" wrote:
> >
> >
> >>I'm probably not understanding but I'll take a shot . . . assuming the bubble
> >>chart is similar to an XY Scatter chart, wouldn't you set your data up like
> >>this:
> >>
> >>x y size
> >>2 5 0.25
> >>4 6 0.46
> >>6 8 0.68
> >>9 6 0.96
> >>
> >>The coordinates as you've presented them looked like they might be swapped.
> >>Can you post back with an example similar to that above of how your data is
> >>set up?
> >>
> >>----
> >>Regards,
> >>John Mansfield
> >>http://www.pdbook.com
> >>
> >>"laszlo" wrote:
> >>
> >>
> >>>I would like to place bubbles on the 2D places (x,y) with different radius.
> >>>The coordinates are the (column, row) an´d the rtadius the value in the cell
> >>>(column, row). For example the value 0.25 in the cell (2,5) means, that a
> >>>bubble with radius 0.25 placed on the 2D coordinate system at the location
> >>>x=2, y=5.
> >>>
> >>>How to do it ? The bubble chart places the bubbles on the location (column,
> >>>radius).
> >>>
> >>>Thanks in advance, Laszlo
>

hi laszlo

i understood your problem because i have the same problem!
i just posted it.
i don´t want to rearrange the table too since i want to have the values in it getting the bubbles in it too.
did u find a solution in the meantime??

thanks
haydar