There are unrelated problems with line or scatter series which are unable to
be plotted due to having no valid data (i.e., all blanks or all errors). You
could temporarily change the chart type: a column or area chart lets you
access the series formula of a series which would be inaccessible as a line
or XY type.

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


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

I got the new add-in, thanks. No problems with integrating it into my
workbook.
Well done.

This doesn't mean you copied code into your workbook, right? That's what
you were
doing before and it wasn't necessary. It's especially not necessary now.
Just
activate the sheet with your charts and use the buttons.

As stated previously I would like to change the last 3 digits in the
'Values'
field,

If you were doing a find-replace in the worksheet for three characters,
you would
change just those three characters, right? You want to change row 150 to
row 170
in the cell references. So in the Find box, enter:

$150

and in the Replace With box, enter:

$170.

This changes all instances of $150 in all series formulas in the active
chart,
meaning all X values and all Y values for all relevant series.

The line in the code producing the error is below.
mySrs.Formula = WorksheetFunction.Substitute(mySrs.Formula, strFrom,
strTo)

This line has been altered in the new version of the utility to allow for
a
graceful exit in the event of this kind of error. Are you sure you have
removed
the old version of the utility?

The program now uses an intermediate variable sFormula, splitting the
above line
into two lines:

sFormula = WorksheetFunction.Substitute(mySrs.Formula, strFrom, strTo)
mySrs.Formula = sFormula

I tried the above on a fresh copy of my spreadsheet. No installation
problems.
However, I do get the following message box after entering data into your
table.

Unknown error

Unable to get the FORMULA property of the series class

The worksheet appears to function OK after entering new values though.

It does not change the values for <blank series in the series, which is
probably
why I get an error message.

I do get <blank series, as most events have differing numbers.

I have a piece of code that copies/pastes the names in the series and
places them in
the 'Archive' worksheet. These are then placed at the foot of the graph
in a legend
for reference.