Hi. My question deals with creating bubble charts and dynamically addin
series. I have data in the Following Format

Col A: Series Name
Col B: X Value
Col C: Y Value
Col D: Bubble Size

All of these colums are linked to other worksheets and could potentall
have as many as 100 values or as few as 10.

In order to get the bubble chart to display correctly, I have bee
manually adding series, and specifing the series name cell, the x valu
cell, the y value cell, and the bubble size cell.

Here is my question. I would like for the chart to be dynamicall
generated regardless of the number of series and data points. I ca
currently add series and data points which are blank, in antipacitio
of being filled, however it produces a blank series entry in the legen
when there is no data, which I dont want. So in essense, is there an
way to dynamically add series, or to hide or ignore blank series in th
chart and legend. Thanks a lot

:

--
Message posted from http://www.ExcelForum.com

Here's a macro I posted a while back that builds a bubble chart, one
series per row, one point per series, with the series name in the same
row as the data:

http://www.google.com/groups?selm=OY...%40tkmsftngp11

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

cassellj < wrote:

> Hi. My question deals with creating bubble charts and dynamically adding
> series. I have data in the Following Format
>
> Col A: Series Name
> Col B: X Value
> Col C: Y Value
> Col D: Bubble Size
>
> All of these colums are linked to other worksheets and could potentally
> have as many as 100 values or as few as 10.
>
> In order to get the bubble chart to display correctly, I have been
> manually adding series, and specifing the series name cell, the x value
> cell, the y value cell, and the bubble size cell.
>
> Here is my question. I would like for the chart to be dynamically
> generated regardless of the number of series and data points. I can
> currently add series and data points which are blank, in antipacition
> of being filled, however it produces a blank series entry in the legend
> when there is no data, which I dont want. So in essense, is there any
> way to dynamically add series, or to hide or ignore blank series in the
> chart and legend. Thanks a lot
>
>
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>