There is no support for the formula calculations in the office chart. Due to this, if the cell that is referred in the chart range has formula, and if the formula-dependent cell values are changed, then it’s not reflected in the chart. Need to provide support for this.