On Sat, 28 Apr 2007, in microsoft.public.excel.charting,
Ira said:
"Del Cotter" wrote:
create your series in the chart, as usual, but using the named
range BUDGET instead of a cell range. I must repeat though, that the
first idea is actually much *more* manageable, not less. But this
solution gets you your single cell budget value with no wasted cells.

I was able create the named range called BUDGET as you described. However I
was unable to use BUDGET as a series value in the Source Data window of the
Chart Wizard.

I think that, as with all uses of a named range in chart series, you
need to explicitly refer to the sheet the data series is in. Because the
chart isn't in any sheet, it can't just assume the name is in its own
sheet, it has to be told.

So if you've written the data in Sheet1, then you need to refer to the
range as Sheet1!BUDGET instead of just BUDGET. See if that works for
you.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.