I’ve noticed a weird behavior on a report dashboard, I thought it was just happening on the dashboard but I replicated the issue by creating a new Excel file for testing. I’ve created a combo graph using stacked on both bars to see the difference between 2 series ( The data will be percentages).

The formulas are:

B4 = A4/A5

B5 = B2 – B4

Now, the Graph is using those 2 values as series for the graph but is not displaying the data correctly. Please see below picture

The weird thing is that if I delete the formula from B4 and I enter manually the value 0.833333 the graph will display the data correctly. Please see below picture

I’m a bit lost here because if I leave the formula and change the cell A4 to a different value, for example 14 it works ( All numbers from 1 to 14 will display correctly but when A4 is either 15,16 or 17 the graph does not display the data correctly unless I manually input the decimal value). For a greater value on Series 1 ( blue bar) the orange bar should be smaller.

The below is incorrect