|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
04-11-2005, 04:06 AM
|
|||
|
|||
|
Create new series (on the same chart) for every change of values in a combobox
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 :-) 
|
|
#2
04-11-2005, 02:06 PM
|
|||
|
|||
|
Re: Create new series (on the same chart) for every change of valuesin a combobox
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 :-) > >
|
|
#3
04-11-2005, 03:06 PM
|
|||
|
|||
|
Re: Create new series (on the same chart) for every change of values in a combobox
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" <jonREMOVExlmvp@peltierCAPStech.com> ha scritto nel messaggio news:Ose9MlqPFHA.2748@TK2MSFTNGP09.phx.gbl... > 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 :-) > > > >
|
|
#4
04-12-2005, 12:06 AM
|
|||
|
|||
|
Re: Create new series (on the same chart) for every change of valuesin a combobox
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" <jonREMOVExlmvp@peltierCAPStech.com> ha scritto nel messaggio > news:Ose9MlqPFHA.2748@TK2MSFTNGP09.phx.gbl... > >>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 :-) >>> >>> > > >
|
|
#5
04-12-2005, 03:06 AM
|
|||
|
|||
|
Re: Create new series (on the same chart) for every change of values in a combobox
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" <jonREMOVExlmvp@peltierCAPStech.com> ha scritto nel messaggio news:Og5H5VwPFHA.3988@tk2msftngp13.phx.gbl... > 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" <jonREMOVExlmvp@peltierCAPStech.com> ha scritto nel messaggio > > news:Ose9MlqPFHA.2748@TK2MSFTNGP09.phx.gbl... > > > >>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 :-) > >>> > >>> > > > > > >
|
|
#6
04-14-2005, 09:06 PM
|
|||
|
|||
|
Re: Create new series (on the same chart) for every change of valuesin a combobox
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" <jonREMOVExlmvp@peltierCAPStech.com> ha scritto nel messaggio > news:Og5H5VwPFHA.3988@tk2msftngp13.phx.gbl... > >>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" <jonREMOVExlmvp@peltierCAPStech.com> ha scritto nel > > messaggio > >>>news:Ose9MlqPFHA.2748@TK2MSFTNGP09.phx.gbl... >>> >>> >>>>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 :-) >>>>> >>>>> >>> >>> >>> > >
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
