We recently acquired and installed Nevron Charts for SharePoint 2010.

When I try to connect to an Excel workbook I get an error:
Error: Cannot connect to data source.  Error was:Exception has been thrown by the target of an invocation.

This is what I did to get to that point.

1. I added a nevron chart web part to a page.

2. In the configuration I put a link to my excel file that I want to reference (http://mysite.com/Shared%20Documents/test.xlsx)

3. Put in the range (A2:B54)

I had a rather involved spreadsheet with a lot of calculations and data and thought maybe I was trying to reference to much so I created a simple sheet with a date column and a currency column and pasted simple values in and saved it as test.xlsx and still no joy. The document is checked in, published as a major version and I am able to view it in excel services in the browser.

PS. The WYSIWYG tools on the forum here seem to be inop, using IE8.

I was able to get the range to work by creating a new named range that only spanned 2 columns. For some reason, named ranges that span a table don't work.

Hello Greg,

Can you please elaborate and send us a sample Excel spreadsheet (snapshot of the one you work with)?

Hello Greg,

You can take a look at the following KB topic: Create Chart by using Dynamic Named Range in Excel Services