Does "find and replace" work within a chart?

's Computer Specifications

"find and replace" (ctrl-h) will not replace text in the legand of my charts.
Is there any way to make this happen?

's Computer Specifications

This page describes how you can change a series formula:

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

Keep in mind that the series formula's first argument relates to the
series name, which appears in the legend. If it's entered as text, this
technique (or the associated add-in) will change it directly. If it's a
cell link, use Find-Replace on the worksheet range containing the series
names.

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

jspalsky wrote:

> "find and replace" (ctrl-h) will not replace text in the legand of my charts.
> Is there any way to make this happen?

's Computer Specifications

Thanks!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Find" a wildcard as a place marker and "replace" with original va	Eric	Microsoft Excel Misc	1	27th Jan 2009 06:00 PM
Replace dialog should put focus on "Find What" not "Replace With"	=?Utf-8?B?TWljaGFlbCBXaWxsaWFtcw==?=	Microsoft Excel Misc	0	24th May 2006 12:45 PM
"replace" and "Find" function in Microsoft Office Word 2003	=?Utf-8?B?bWxlaA==?=	Microsoft Access	1	10th May 2006 11:12 PM
"find" & "replace" functions no longer working in FP2002??	FrontPageCornfuzzled	Microsoft Frontpage	4	19th Feb 2005 12:48 PM
Need to "find" an entire word and "replace" only part of it	=?Utf-8?B?VmljdG9yRA==?=	Microsoft Word Document Management	4	19th Jun 2004 01:46 AM