100% score dipping to below zero

Never come across this before.

On attached, result for March 18 is 100%, but line chart is "dipping" below the baseline!


Any solutions, suggestions or pointers welcome as ever

Ochimus

Change the formatting of all cells to General.
You will know why the graph behaves like this.

You have a mix between Percent formats and General formats. Remember that 100% = 1, 97% = 0.97, etc.

To fix this, change column B to General then make the following changes:

B13 from 1 to 100
B15 from 1 to 100
B16 from 1 to 100
B17 from 0.97 to 97

Many thanks to everyone for prompt explanations.

Not spotting the cell formats were inconsistent will probably win my "stupidest Senior Moment" of the year!

Will now class this as Closed.

Ochimus

Glad we could help.