On Sun, 2 Jul 2006, in microsoft.public.excel.charting,
Kim said:

I am trying to create a bubble chart that has about 10 series. Column A
contains the names, column B the x value, column C the y values and column D
the size. I currently have to manually add each series in the graph. Is
there a way to capture all the series rather than me having to add each
series one by one? Although this graph only has ten series, I have have
about 13 more of these graphs to create, so adding a series one by one can
add up to a lot of time.

Kim, I think you need to set up your ten series columns in order as
follows:

x1, y1, size 1, y2, size 2, ... y10, size 10

Then in a separate area which you do not select when you make your
chart,

Name 1..Name 10, x2..x10

All the series will initially share the first x value, so you will still
have to manually change the x values for series 2 to 10, but this should
save you some time.

Even if, like me, you prefer your charts on a separate sheet, it's worth
designing them embedded in the data sheet at first, because then you can
drag and drop the ranges, which also saves time and effort.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.