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

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


On Jul 14, 12:37*pm, Robert Hatcher <rhatcher...@gmail.com> wrote:
> 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