Connect to the Excel Web Service and enter the full URL of the workbook and the range in that workbook that you want to use ...

Connect to the Excel Web Service and enter the full URL of the workbook and the range in that workbook that you want to use as a data source for your chart.

Example of valid URL: http: Example of valid range: Sheet1!$G$21:$L$30 or the name of a range if you have one labeled in the workbook.