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 :-)

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 :-)

Thank you for your answer,
I just meant what you think, it would be very useful for me do that thing
Maybe I could define a macro to copy and paste th 16 pairs of columns in
another sheet...and then chart them...uhm...I'll think on it...


"Jon Peltier" ha scritto nel messaggio
...
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 :-)

Wouldn't it be quicker to just copy and paste than to struggle with a macro?

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

uriel78 wrote:
Thank you for your answer,
I just meant what you think, it would be very useful for me do that thing
Maybe I could define a macro to copy and paste th 16 pairs of columns in
another sheet...and then chart them...uhm...I'll think on it...


"Jon Peltier" ha scritto nel messaggio
...

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 :-)

Well, for a single sworkbook it would be surely easier, but in my case I've
got several (N) workbooks to process in such a way...
and for every workboosks I've got three types of charts to plot...:-) and
I'll get crazy to copy and paste 3x16xN pairs of data....







"Jon Peltier" ha scritto nel messaggio
...
Wouldn't it be quicker to just copy and paste than to struggle with a
macro?

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

uriel78 wrote:
Thank you for your answer,
I just meant what you think, it would be very useful for me do that
thing
Maybe I could define a macro to copy and paste th 16 pairs of columns in
another sheet...and then chart them...uhm...I'll think on it...


"Jon Peltier" ha scritto nel
messaggio
...

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 :-)

Set up one workbook, with the data and charts. Save it, then save as
with a new name. Copy the data from wherever it is, and use paste
special to paste it as values into the newly named workbook on top of
the existing data. Save, save as, copy, paste special values, etc.

- Jon

uriel78 wrote:
Well, for a single sworkbook it would be surely easier, but in my case I've
got several (N) workbooks to process in such a way...
and for every workboosks I've got three types of charts to plot...:-) and
I'll get crazy to copy and paste 3x16xN pairs of data....







"Jon Peltier" ha scritto nel messaggio
...

Wouldn't it be quicker to just copy and paste than to struggle with a

macro?

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

uriel78 wrote:

Thank you for your answer,
I just meant what you think, it would be very useful for me do that

thing

Maybe I could define a macro to copy and paste th 16 pairs of columns in
another sheet...and then chart them...uhm...I'll think on it...


"Jon Peltier" ha scritto nel

messaggio

...


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 :-)