View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cinque Terra Cinque Terra is offline
external usenet poster
 
Posts: 11
Default 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