Bubble Chart Series Question

  • Thread starter Thread starter cassellj
  • Start date Start date
C

cassellj

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

:
 
Back
Top