Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does "find and replace" work within a chart?
"find and replace" (ctrl-h) will not replace text in the legand of my charts.
Is there any way to make this happen? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
VB Find and Replace | Excel Worksheet Functions |