ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Bubble charts: just size, no x/y (https://www.excelbanter.com/charts-charting-excel/223244-bubble-charts-just-size-no-x-y.html)

lcoleman

Bubble charts: just size, no x/y
 
I am hoping to recreate a bubble chart with excel that I previously created
online. However, I'm not sure if it is possible. The online chart expresses
the relationship of elements to one another using the size (similar to the
excel bubble chart option) but without the need for x and y values. See an
example he
http://manyeyes.alphaworks.ibm.com/m...industry-types

Thanks,
--
lcoleman

Shane Devenshire

Bubble charts: just size, no x/y
 
Your link takes me to "Sorry, we couldn't find the page you were looking for"

You can of course create dummy x and y series to allow you to place the
bubbles whereever you want them. But a bubble chart does require those
series or the bubbles will overlap most likely.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"lcoleman" wrote:

I am hoping to recreate a bubble chart with excel that I previously created
online. However, I'm not sure if it is possible. The online chart expresses
the relationship of elements to one another using the size (similar to the
excel bubble chart option) but without the need for x and y values. See an
example he
http://manyeyes.alphaworks.ibm.com/m...industry-types

Thanks,
--
lcoleman


Jon Peltier

Bubble charts: just size, no x/y
 
The site is
http://manyeyes.alphaworks.ibm.com/m...industry-types

You don't see the X and Y axes, and they're not explicitly scaled to actual
variables. They are, however, used to position the bubbles, and behind the
scenes there is code that dynamically adjusts these X and Y coordinates as
options are chosen.

This is possible in Excel, but it sure would take a lot of coding.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Shane Devenshire" wrote in message
...
Your link takes me to "Sorry, we couldn't find the page you were looking
for"

You can of course create dummy x and y series to allow you to place the
bubbles whereever you want them. But a bubble chart does require those
series or the bubbles will overlap most likely.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"lcoleman" wrote:

I am hoping to recreate a bubble chart with excel that I previously
created
online. However, I'm not sure if it is possible. The online chart
expresses
the relationship of elements to one another using the size (similar to
the
excel bubble chart option) but without the need for x and y values. See
an
example he
http://manyeyes.alphaworks.ibm.com/m...industry-types

Thanks,
--
lcoleman





All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com