How can users display data from the worksheet in SharePoint without having to create a list with columns? As you know, Excel Services is a service application that you can use to load, calculate, and display Microsoft Excel workbooks on Microsoft SharePoint Server 2010.
For this reason, the just-released release of Chart Plus R3.5 supplies one more option for getting data from an Excel file through the Excel Services.
Here's how it works:
First, open your site and go to any Shared Documents list, then upload some Excel files that you want to use:
You can click on each list to see data. Specifically, you can upload Excel 2007, Excel 2010, and Excel 2013 files to a list for use in Chart Plus.
Note: Chart Plus does not support Excel 2003 files.
Next, modify the Chart Plus tool pane to configure.
Go to the Data Source Settings tab and select Excel Services mode as pictured below:
Then, go to the Excel Services tab.
In the Excel Workbook Path field, type the URL of the Excel file which you uploaded to the Shared Documents list earlier. You must enter the path with the following syntax: http://servernam/listname/filename.xlsx
Also, you can use a Relative path or an Absolute path in the Excel Workbook Path field.
Moreover, you can get data from other sub-sites, other sibling sites, and on other site collections in the same Web Application.
Note: Only use Relative path for current site collections, not other site collections. Chart Plus cannot get data from other Web Applications.
In addition, you can define new trusted file locations to expand workbook capabilities and tighten security. Please see Manage Excel Services trusted locations (SharePoint Server 2010) for additional information.
In the Worksheet Name field, type the Name of the worksheet in the Excel file that you want to use.
In the Range Name field, type SheetName!$A$1:$H$30 following data that you want to show on Chart Plus.
Click the Load data button.
In the X-Axis Category drop-down list: select a column name that you want to use.
In the Y-Axis Series list box, select some columns that you want to use.
Click the Preview button.
You will see a preview from Chart Plus:
Why wait? Read the entire User's Guide to Chart Plus 3.5 series now:
Oct 23 2012, 09:30 AM