Jon Peltier wrote:

Set up your chart by defining some names. Go to Insert menu Names
Define. In the dialog, enter a name for the first named range and a formula
to refer to it:

Do I do this from the Data or Archive worksheet, or does it make no
difference?

Thanks again.