Where is the -0 Value coming from?

Thanks @Camelot, that fixed it! Odd though because the thing is these numbers are ascending as they head from row 2, past row 58 and onwards because they get larger being based off values in col A (which increases down the column).

After row 58 they start to eventually increase to positive integers) which makes the cause of the random oddly placed -0.00 numbers hard to fathom?

Hi @Cameron, pls don't worry about the Matching formula Rounding request.

Problem: With the rounding added and removal of a few -0.00 values, the data, is to all intents the same but now the chart plots the data with no buffer below the zero value on the Y axis which looks bad.

Image 1 is with rounding, image 2 is before the rounding was added to the same data and visually far better).

How can I get a buffer when I can't auto set and exact amount eg -18000 because there will be data that will exceed -18000?

Also do you know what is making the +3000 buffer (visually better) on this original non rounded data/chart? There wasn't an issue with random -0.00's in the data column. I need to get the buffers back but can't think of a way of doing that knowing that the data set can change to very different large numbers for the min / max values.

Thanks

Now I'm really wondering.... why there were a few odd -0.00's in my column/table that you kindly fixed.

I have two tables and they use the same formula as in the screenshot above, one of which had to have a Round() formula added to it... because I just noticed that, using this same formula (that needed to be Rounded() to eliminate the -0.00's) -- the exact same (non rounded) formula didn't produce any -0.00's at all in this column in this image attached.

Pls note, the red lines showing non negative 0.00's on the same rows where there were -0.00's and which were eliminated by Rounding?

What could be really causing the -0.00's in the first table in the orig post but not the second in the image provide here?

Thanks again!

I noticed another column that is using a Matching formula (to apply data to a chart) and that is has random -0.00's too...

Struggling with how to add Round() to the following formula though? :

IF('Control 1 - Profit and Loss'::$I$3 = "", "", 
    IF(ISBLANK(OFFSET($A$2, ROW(cell)− ROW($EK$2), MATCH('Control 1 - Profit and Loss'::$I$3, A$1:DE$1,0) − 1,rows,columns)),
        "",
        IFERROR(OFFSET($A$2, ROW(cell)− ROW($EK$2), MATCH('Control 1 - Profit and Loss'::$I$3, A$1:DE$1,0) − 1,rows,columns), "")
    )
)

Cheers

Thanks for the suggestions. Dummy Data: It won't affect your main plot.

How would I hide what's plotted with this second series?

Great, thanks for configuring that example for me, I'll give it a go.