Does "find and replace" work within a chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

"find and replace" (ctrl-h) will not replace text in the legand of my charts.
Is there any way to make this happen?
 
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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Charts/formulas will not adjust? 0
Replace values in chart 1
Labels in a chart 3
Replacing Chart title with Text box 2
How to create a bubble chart with more than 2 variables 0
The equivalent of a Find & Replace option 4
change source data in multiple charts 5
Excel 2007 - problems with macro to change series formula 3

Back
Top