Chart Plus: How to Obtain a Data Source Stored in Microsoft Business Connectivity Service (BCS)

Business Connectivity Services (BCS) is a centralized infrastructure in SharePoint® that supports integrated data solutions. The BCS brings external data into SharePoint by creating an external content type. This means, of course, that the configuration data is stored in an external content type. External content types are stored in the BCS.

Question: Do we directly obtain the data source stored in Microsoft Business Connectivity Services in Chart Plus?

Answer: Yes.

In two simple steps, you can create a chart from data stored in BCS.

In the example below, I”ll choose from two external content types:

This is the default settings of BCS.

Click the Book picker button. Select Application Name on List Applications Picker popup. Click OK.

You will see two external contents types stored in the BCS in the Entity drop-down.

I will choose the Products option to create a chart.

And here is my Donut chart.

Good luck!

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!