You're making it too hard on yourself. You don't have to copy and paste any
code. Just use the button on the floating toolbar to use the code on any
sheet.

The interface couldn't be more straightforward. Whenever you have a find and
replace, there's an old text string you want to change to a new text string.
Enter the old string into the Old String box, and the new string into the
New String box. The options and buttons are self-explanatory.

If you ask the program to insert code that invalidates the series formula,
the formula is not changed. Clear the error, and try something else.
Changing a comma to a semicolon, for example, will cause this type of error,
or changing a column address ($A$) to something invalid (3) will also fail,
as will changing the sheet name to the name of a nonexistent sheet. Valid
sheet names that contain spaces and other special characters also lead to
failure due to incongruities in the VBA Charting object model. I have
workarounds in mind, but I have not had an opportunity to implement them in
this free utility.

In any case, I've made some changes to the utility, in hopes it's even
easier to use, more self-explanatory, and tolerant of errors in new series
formula strings. I've updated this page to describe it:

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

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


"Saxman" wrote in message
...
Jon Peltier wrote:

I don't know why you had problems installing the utility.... Guess I'll
have to
look into it. What Excel version?

Select the series, and look in the formula bar. That is the series
formula, which
my utility operates on. You don't see

=Archive!$A$2:$A$150

anywhere in the series formula, so nothing changes. However, you probably
see
something like

$A$2:$A$150

and using the utility you could change it to

$B$4:$B$200

if you were so inclined. To change $A$2:$A$150 to $B$2:$B$150, simply use
$A$ as
the old string and B as the new string.

Thanks for the feedback. I am using Excel 2003. I don't have trouble
installing
it, it's knowing what to do with it from a layman's point of view.

How do I apply your 'Sheet 1' worksheet to another workbook (containing a
graph)?

I have pasted a graph into 'Sheet 1' of your workbook, entered new values
and tried
to change them using your form, but I get a runtime error.

I have also copied your code and pasted it into my workbook, but I am
unable to run
it, as there is no way to activate the form (as I have explained in
another posting).

It might be easier saving several workbooks with different values and
applying each
one to different situations? Sounds laborious, but so is changing code
about 16
times in a worksheet.

Thanks again.