How to Display Excel Data in a Chart

How to Display Excel Data in a Chart

Configuring Chart Plus

Displaying Excel Data in a Chart

Excel Services allows you to display Excel data in a Chart in Chart Plus 3.5 for SharePoint 2010. The new Excel Services Settings screen gives you the ability to select a range of data from an Excel Workbook to display in your Chart.
When Excel Services is selected as your Chart Plus Data Source, the Excel Services screen will be available under Data Connection Settings

hw27v35-uc16-2.jpg

To create a connection to Excel Services, you will need to follow these steps:

  1. Enter the Excel Workbook Path (the absolute or relative path) for the URL of the workbook that you want to use as a data source for your chart.
    Example of absolute URL ( http ://abc.com/sites/XYZ/Shared20Documents/xyz.xlsx) or relative URL (./sites/XYZ/Share%Documents/xyz.xlsx).

Note: file must be stored in a trusted file location. Refer to Microsoft TechNet article Manage Excel Services trusted locations SharePoint Server 2010 for configuring Excel Services trusted locations.

  1. Enter the Worksheet Name that you want to use as a data source for your chart.
  2. Enter a Range, such as SheetName!A$1:$D$4, or the name of a range if you have one labeled in the workbook.
  3. Determine which columns will be displayed on the X-Axis Category and Y-Axis Series of the chart.

hw27v35-uc16-3.jpg

Now that the chart is configured to reference data from Excel Services, you can fine tune the appearance of your chart so that it has maximum impact.