I sense that you're trying to shortcut the process of defining 16 series
in the chart. I can think of ways to do this in code, but I think the
easiest thing to do is create 16 pairs of columns with the data, make a
chart with the first pair of columns, then in turn copy each of the
other 15 and use paste special to add each to the chart as a new series.

The data validation approach is good if you want to give the user a
chance to see how their choice of parameters will affect the charted values.

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

uriel78 wrote:

Just a little variation over the theme of the 3ad of last week:

I've got a *scatter* chart that takes values from cells A1:B100

In C1 and in D1 I've got two combobox (created with data validation method),
each one allows me to choose 4 different parameters. By changing these
values, the values in A1:B100 and the chart change too.

Is there a way to insert *new series on the same chart* every time I change
parameter in C1
and D1, so that I can avoid to do the copy & paste single series manually?

Thanks in advance, any help would be appreciated :-)