The equivalent of a Find & Replace option

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

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 - 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...
 
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...
 
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
 
Back
Top