Is there way to "Find & Replace" some text (current date) in a multitude of
graphs/charts in Excel?
I have a workbook with 17 tabs with around 80 graphs/charts that need to
have the date changed on a weekly basis. Currently I am copying the new date
and pasting into each one, but figured someone would have a better solution.

Any ideas are greatly appreciated.

Thank you!

Put the date into a cell. Next time you replace them all in the charts,
inset a textbox that's linked to this cell. The easy way to do this is to
select the chart, click in the formula bar, type =, then click on the cell.
This textbox will be linked to the cell and update accordingly.

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


"Pat" wrote in message
...
Is there way to "Find & Replace" some text (current date) in a multitude
of
graphs/charts in Excel?
I have a workbook with 17 tabs with around 80 graphs/charts that need to
have the date changed on a weekly basis. Currently I am copying the new
date
and pasting into each one, but figured someone would have a better
solution.

Any ideas are greatly appreciated.

Thank you!

Jon - This worked very well, thank you...
Of course this raised a new question. Once I have moved the date into where
I believe I would like to put it (In the Chart Title) once I have released
the textbox, I am having difficulty re-opening the dated textbox to make
minor adjustments. Only the "Chart Title" is opening, not the dated
textbox... This most likely very simple, but just the same.. I'm stumped, any
additional info is greatly appreciated!!!

Thanks...

"Jon Peltier" wrote:

Put the date into a cell. Next time you replace them all in the charts,
inset a textbox that's linked to this cell. The easy way to do this is to
select the chart, click in the formula bar, type =, then click on the cell.
This textbox will be linked to the cell and update accordingly.

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


"Pat" wrote in message
...
Is there way to "Find & Replace" some text (current date) in a multitude
of
graphs/charts in Excel?
I have a workbook with 17 tabs with around 80 graphs/charts that need to
have the date changed on a weekly basis. Currently I am copying the new
date
and pasting into each one, but figured someone would have a better
solution.

Any ideas are greatly appreciated.

Thank you!

My apologies, I didn't click on one of the corners of the textbox, so it
wasn't opening for me, just a matter of clicking on the right area. (Duh!)
Once again, thanks...

"Pat" wrote:

Jon - This worked very well, thank you...
Of course this raised a new question. Once I have moved the date into where
I believe I would like to put it (In the Chart Title) once I have released
the textbox, I am having difficulty re-opening the dated textbox to make
minor adjustments. Only the "Chart Title" is opening, not the dated
textbox... This most likely very simple, but just the same.. I'm stumped, any
additional info is greatly appreciated!!!

Thanks...

"Jon Peltier" wrote:

Put the date into a cell. Next time you replace them all in the charts,
inset a textbox that's linked to this cell. The easy way to do this is to
select the chart, click in the formula bar, type =, then click on the cell.
This textbox will be linked to the cell and update accordingly.

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


"Pat" wrote in message
...
Is there way to "Find & Replace" some text (current date) in a multitude
of
graphs/charts in Excel?
I have a workbook with 17 tabs with around 80 graphs/charts that need to
have the date changed on a weekly basis. Currently I am copying the new
date
and pasting into each one, but figured someone would have a better
solution.

Any ideas are greatly appreciated.

Thank you!

If you want the date included in the chart title, construct the entire label
in a cell:

="Test Run On "&TEXT(NOW(),"D-MMM-YY")

then link the chart title to this cell in the same manner you linked the
textbox to a cell: select the title, click in the formula bar, type =, then
click on the cell.

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


"Pat" wrote in message
...
My apologies, I didn't click on one of the corners of the textbox, so it
wasn't opening for me, just a matter of clicking on the right area. (Duh!)
Once again, thanks...

"Pat" wrote:

Jon - This worked very well, thank you...
Of course this raised a new question. Once I have moved the date into
where
I believe I would like to put it (In the Chart Title) once I have
released
the textbox, I am having difficulty re-opening the dated textbox to make
minor adjustments. Only the "Chart Title" is opening, not the dated
textbox... This most likely very simple, but just the same.. I'm stumped,
any
additional info is greatly appreciated!!!

Thanks...

"Jon Peltier" wrote:

Put the date into a cell. Next time you replace them all in the charts,
inset a textbox that's linked to this cell. The easy way to do this is
to
select the chart, click in the formula bar, type =, then click on the
cell.
This textbox will be linked to the cell and update accordingly.

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


"Pat" wrote in message
...
Is there way to "Find & Replace" some text (current date) in a
multitude
of
graphs/charts in Excel?
I have a workbook with 17 tabs with around 80 graphs/charts that need
to
have the date changed on a weekly basis. Currently I am copying the
new
date
and pasting into each one, but figured someone would have a better
solution.

Any ideas are greatly appreciated.

Thank you!