User’s Guide to Chart Plus 3.5, Part 3: Using an External List

As you may already know, an External List is used to display content that comes from Business Connectivity Services (BCS) Enterprise content types in Chart Plus.

To do this, you must first create an External List, and in order to create an External List, you must first create an External Content Type. For instructions on how to create an External Content Type, please refer to the TechNet article, How to: Create an External Content Type Based on a SQL Server Table.

Note: In the Filter Parameters Configuration screen, enter a Filter Limit of 1000 as the Default Value. If the Default Value is not set to 1000, the external system may fail to return any data.


After you have created an External Content Type, you can create an External List. Refer to the TechNet article How to: Create External Lists in SharePoint for instructions on how to create an External List.

To create a chart using data stored in an External List, select SharePoint List or Library as your data source and select the external list that you created:


The data will be shown in a Chart:

Otherwise, you can use the Runtime Filter View option to limit data displayed in the Chart:


Why wait? Read the entire User's Guide to Chart Plus 3.5 series now:

All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019


Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.

Essentials Suite

Essentials Plus Suite

Bamboo Premier Suite

Project Management Suite

Knowledge Management Suite

External User Manager


For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!