Chart data - Range Names

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
 
L

Luke M

You need to include name or workbook in the formula.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Charts 3
chart with data source from multiple worksheets 2
Named ranges with dependencies 4
Chart SERIES OFFSET 3
Input a Value to Lookup the Data Series for a Chart 5
Rank and return Names 5
Automatically shift chart data range 4
Problems with 'Names' 1

Top