Remove empty data from the data source in Chart for SharePoint

Applies to: Nevron Chart for SharePoint (WSS3.0, SharePoint 2007/2010/2013)

How to remove empty data from the data source in Chart for SharePoint?

In Nevron Chart for SharePoint, you can easily filter the data source and remove empty data entries (empty data points) from your charts. For example, let’s say you have a SharePoint list with some empty data (missing data for August and November):

Figure 1: sample SharePoint list with empty data

In this example we will generate and configure a line series chart. Once we bind the Chart to the SharePoint list, the result will be similar to:

Figure 2: line chart in SharePoint with empty data points

In order to plot the chart without showing the empty data points, we have to add a Filter Expression in the Pivot, which will remove the empty data entries (global Filter or Category Filter). For example:

Figure 3: adding a global Filter Expression

Figure 4: adding a Filter Expression for the Categories

Figure 5: Expression Editor in Nevron Chart for SharePoint

This will remove August and November from the plot, producing the following result:

Figure 6: line chart in SharePoint with removed empty data points

Article ID: 155, Created On: 12/7/2010, Modified: 1/29/2013