Named ranges in charts

[JK1234]

I have used named ranges in charts and worked fine. Its been a while and I named some ranges as usually, then when I aselect the chart and try to modify the values by inputting the new name (is range B8:B1000) it wont take it. I know I must just not rememeber how to do it. Got me frustrated.

I tried many things: { and ={" etc.....

how do I type in the name so it works????

HELP

[jeffreybrown]

Here is an example...

http://peltiertech.com/Excel/Charts/Dynamics.html

[teylyn]

Hi,

that's one my Excel pet hates! For data validation it is fine to write =RangeName but in the charting data source box you have to write

='Sheet Name'!RangeName

Remember to put the Sheet Name in single quotes if it contains blanks! If not, you can omit the quotes.
When you next look at your data source definition in the Chart dialog, you will find that Excel has replaced your entry with

=[FileName.xls]'Sheet Name'!RangeName

Go figure.