Prev: Dynamic Range
Next: charts and pivot tables
From: Tuxla on 4 Jul 2008 06:58
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
From: Shane Devenshire on 4 Jul 2008 10:27
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" <Tuxla(a)discussions.microsoft.com> wrote in message
news:92457D68-7954-4FB4-9B66-FD26748DA8B1(a)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

From: Tuxla on 4 Jul 2008 10:41
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" <Tuxla(a)discussions.microsoft.com> wrote in message
> news:92457D68-7954-4FB4-9B66-FD26748DA8B1(a)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
>
>
From: Jon Peltier on 4 Jul 2008 13:38
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" <Tuxla(a)discussions.microsoft.com> wrote in message
news:92457D68-7954-4FB4-9B66-FD26748DA8B1(a)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


From: Tuxla on 7 Jul 2008 03:27
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" <Tuxla(a)discussions.microsoft.com> wrote in message
> news:92457D68-7954-4FB4-9B66-FD26748DA8B1(a)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
>
>
>
 | 
Pages: 1
Prev: Dynamic Range
Next: charts and pivot tables