Chart with Named Range error


R

Robert Hatcher

Using Excel 2007, creating a chart using named ranges as inputs when I
try ti enter the named range as a source I get a formula error "the
formula you typed containes an error..."

So I setup a simple scenario to dumlicate the problem.
named a range of cells "Test" and entered arbitrary numbers in the
cells of the range.
Insert chart, Right click on the chart and select "select data" then
"add"
In the box type "=Test" or used the "Use in formula/paste name" tool.
Select ok and get the formula error.

I dont think I had any problems with this in the past but I haved
needed to use a dynamic rage in a chart for some time.

What am I doing wrong?
Thanks
Robert
 
Ad

Advertisements

R

Robert Hatcher

Ahhh! just remebered I need to include the sheet name in the formula
for a named range.
Sorry for the wasted thread.
 

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

Top