Dear Sirs,

I was trying to make dynamic chart in my level.... But it was not working....

The real issues which I am facing is,
1. There is many pages in the workbook, and i have to select the data from that particular sheet.

I used the below formula to find the relevant data with reference to a cell. I gave the freedom to select the sheet name from the reference cell.
the formula is,
=OFFSET(INDIRECT("'"&$B15&"'!$A5:$A600"),0,0,COUNT A(INDIRECT("'"&$B15&"'!$A5:$A600")))
The reference cell is B15.

I entered this formula to Name Manager (Ctrl+F3) with a Name.
In graph, I tried to enter the formula in axis value wtih the Name (which is provided in the name), excel shows, " That function is not Valid ".
After clicking OK to proceed, excel is showing that the range is already selected.

Please help...
Where is the error occured???

Thanks for the support