Chart data - Range Names

  • Thread starter Thread starter Cinque Terra
  • Start date Start date
C

Cinque Terra

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
 
You need to include name or workbook in the formula.

=SERIES(YourWorkBook!Title_JE,YourWorkBook!Data_Dates,YourWorkBook!Data_JE,1)
 
Back
Top