change source data in multiple charts   

Hi
I have over 30 charts where I need to change the source data and it's taking 
ages doing it manually, especially as each chart has 3 or 4 series. Is there 
an easy way of doing this, please?
I've tried find and replace, but that doesn;t work
Thanks

date: Fri, 4 Jul 2008 03:58:01 -0700   author:   Tuxla

Re: change source data in multiple charts   

We need a little more detail.  1. Are you modifying all the charts to use 
the same new range or does each chart use a different new range?  Is the 
data compact, that is, if you choose the chart wizard and look at the Data 
Range tab does the Data Range box contain a simple reference like 
=Sheet1!$B$2:$E$7?

Thanks,
Shane

"Tuxla"  wrote in message 
news:92457D68-7954-4FB4-9B66-FD26748DA8B1@microsoft.com...
> Hi
> I have over 30 charts where I need to change the source data and it's 
> taking
> ages doing it manually, especially as each chart has 3 or 4 series. Is 
> there
> an easy way of doing this, please?
> I've tried find and replace, but that doesn;t work
> Thanks

date: Fri, 4 Jul 2008 07:27:03 -0700   author:   Shane Devenshire

Re: change source data in multiple charts   

Hi
The charts will all be using different data ranges, but they are all in the 
same column, which is why I thought find and replace might work.
Yes, the data is compact. All I want to do is change the column letter (eg 
from column B to column C)
Thanks

"Shane Devenshire" wrote:

> We need a little more detail.  1. Are you modifying all the charts to use 
> the same new range or does each chart use a different new range?  Is the 
> data compact, that is, if you choose the chart wizard and look at the Data 
> Range tab does the Data Range box contain a simple reference like 
> =Sheet1!$B$2:$E$7?
> 
> Thanks,
> Shane
> 
> "Tuxla"  wrote in message 
> news:92457D68-7954-4FB4-9B66-FD26748DA8B1@microsoft.com...
> > Hi
> > I have over 30 charts where I need to change the source data and it's 
> > taking
> > ages doing it manually, especially as each chart has 3 or 4 series. Is 
> > there
> > an easy way of doing this, please?
> > I've tried find and replace, but that doesn;t work
> > Thanks 
> 
>

date: Fri, 4 Jul 2008 07:41:00 -0700   author:   Tuxla

Re: change source data in multiple charts   

I've built a small utility that manages simple changes for you. To change a 
column, change (for example) $A$ to B. If you just change A to B, it may 
also change the letter A in a sheet name.

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

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


"Tuxla"  wrote in message 
news:92457D68-7954-4FB4-9B66-FD26748DA8B1@microsoft.com...
> Hi
> I have over 30 charts where I need to change the source data and it's 
> taking
> ages doing it manually, especially as each chart has 3 or 4 series. Is 
> there
> an easy way of doing this, please?
> I've tried find and replace, but that doesn;t work
> Thanks

date: Fri, 4 Jul 2008 13:38:18 -0400   author:   Jon Peltier

Re: change source data in multiple charts   

that's great, very useful. thank you

"Jon Peltier" wrote:

> I've built a small utility that manages simple changes for you. To change a 
> column, change (for example) $A$ to B. If you just change A to B, it may 
> also change the letter A in a sheet name.
> 
> http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
> 
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
> 
> 
> "Tuxla"  wrote in message 
> news:92457D68-7954-4FB4-9B66-FD26748DA8B1@microsoft.com...
> > Hi
> > I have over 30 charts where I need to change the source data and it's 
> > taking
> > ages doing it manually, especially as each chart has 3 or 4 series. Is 
> > there
> > an easy way of doing this, please?
> > I've tried find and replace, but that doesn;t work
> > Thanks 
> 
> 
>

date: Mon, 7 Jul 2008 00:27:04 -0700   author:   Tuxla

Re: change source data in multiple charts   

Hi,

We need more detail - is each chart being plotted from the same range or is 
each chart plotted from a different range?  If it’s the "source data" that 
is changing why do you need to change anything - charts are dynamic and 
update automatically?  If you are plotting different ranges when the data 
changes, how does the new data range relate to the old data range?  Does it 
move one column to the right, or down one row, or what.  Is the new data in 
a completely different part of the spreadsheet/workbook and if so how do you 
know where it will be?

Give us an example - the original data plots A2:C20 and the new plot will be 
D2:F20 or what ever.

Thanks,
Shane

"Tuxla"  wrote in message 
news:92457D68-7954-4FB4-9B66-FD26748DA8B1@microsoft.com...
> Hi
> I have over 30 charts where I need to change the source data and it's 
> taking
> ages doing it manually, especially as each chart has 3 or 4 series. Is 
> there
> an easy way of doing this, please?
> I've tried find and replace, but that doesn;t work
> Thanks

date: Thu, 4 Sep 2008 07:38:52 -0700   author:   Shane Devenshire