Chart data - Range Names
 

I have a chart with three data series. I would like to use range names to
define the data ranges. However, when I do so, I get an error saying 'A
formula in this worksheet contains one or more invalid references. Verify
that your formulas contain a valid path, workbook, range name, and cell
reference.' I have verified that the range names refer to the ranges in the
existing series formula.

Replace:
=SERIES('owssvr(1)'!$F$1,'owssvr(1)'!$E$11:$E$22,' owssvr(1)'!$F$11:$F$22,1)

With:
=SERIES(Title_JE,Data_Dates,Data_JE,1)

Thanks in advance!
Sandy

Chart data - Range Names
 

You need to include name or workbook in the formula.

=SERIES(YourWorkBook!Title_JE,YourWorkBook!Data_Da tes,YourWorkBook!Data_JE,1)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Cinque Terra" wrote:

I have a chart with three data series. I would like to use range names to
define the data ranges. However, when I do so, I get an error saying 'A
formula in this worksheet contains one or more invalid references. Verify
that your formulas contain a valid path, workbook, range name, and cell
reference.' I have verified that the range names refer to the ranges in the
existing series formula.

Replace:
=SERIES('owssvr(1)'!$F$1,'owssvr(1)'!$E$11:$E$22,' owssvr(1)'!$F$11:$F$22,1)

With:
=SERIES(Title_JE,Data_Dates,Data_JE,1)

Thanks in advance!
Sandy