Mystery Dynamic Chart Problem

[Tiger73jo]

Hello Experts,

The template file is the ideal situation. I add numbers to column B shown in Picture 1 then picture 2 shows the min and max values, 10 paces, and the 85th, on which the dynamic graph depends. The problem is in excel file 11. the 10 pace is wrong in the chart and the graph. I tried about 100 different data and they all work fine.

Thank you,

[Greg M]

Hi there,

I certainly haven't gone through your worksheet in detail, but could the problem be that the array formulas in Cells AJ21:AK35 and AO21:AP35 need to be extended downwards as far as Row 38?

Hope this helps.

Regards,

Greg M

[Tiger73jo]

Thank you for your reply. I don't know how to do that.

[Greg M]

Hi again,

Select Cells AJ21:AJ38. Press the F2 key. Press Shift+Ctrl+Enter (to enter an array formula).

Do the same for the other three columns.

Hope this helps.

Regards,

Greg M

[Tiger73jo]

It worked. You are the best.

Thank you,

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M