How to solve wrong chart display issues when data cell has empty values in template

Purpose:

You execute the web-template and want the chart to be displayed based on the values in the data cells. But the chart is displayed incorrectly.

Overview:

You have a web-template which contains chart item. The web-template contains empty value for one of the data cell (see below screen).

Now when you see the chart for this data values , you notice that empty values is wrongly displayed in chart (see below screen).

Inorder to correct this please follow below steps:

Open the template in the WAD

Goto chart item

Edit the chart.

In the "Global Settings",  change the value for the "Gaps" from "interpolated" to "Zero".  (see below screen)