Hello,
A am attempting to create a dynamic chart, and have followed the tutorial
for dynamic charts listed here.

My problem is that i always get an error saying "A formula in this worksheet
contains on or more invalid references". I even created a brand new sheet,
replicated all the data from the tutorial, named the cells identical, scroll
bar values identical, and still get the error when trying to create the chart.

My question is this: How do you create a chart with the series formula? I
created a regular chart using the wizard, then selected the series in the
formula bar and changed the cell references to the dynamic references and
still get the invalid reference alarm.

Can anyone help? Do I need an add-in or something for the formula to work
correctly?

Frustrated,
Bruce