Horizontal Bar Chart - Dynamic?

Hi Teylyn,
It's 5.22am here.
Just got your reply, many thanks.

I've just downloaded it.
Still an issue I'm afraid Teylyn.
1st, for clarity, when you say "The Chart",, The top chart, IE the Equity Graph does change every time you hit F9, that has always been fine.
What isn't changing is the Win/Loss Frequency Horizontal Chart; this is the one I really would like to see refreshing as well.

Your new excel sheet does open without a warning message Teylyn, How did you do that ?,, not sure what that was..
If I click now to Un-hide the columns (So I can view Columns K to S,,, The Win Column (N) & Loss Column (O) still don't update like Column K (Count & Column L (Repeat)
N & O,,, these are the problems,, not sure why they don't update?
Also, if these updated, then so should Columns Q & S,, Win % & Loss %??

I really don't know why they don't update Teylyn,, any ideas?
Many thanks for trying again,, it is most frustrating


As a note,, I noticed Column R (IE CELL R12 - is formula like an array,, that column must have been me,, no need to be like {=P12+1},, can be just =P12+1 ,,, Is this right Teylyn?

Again, many thanks for your help, it really is frustrating,, I take it you must be viewing the excel sheet and seeing the Win/Loss Frequency chart updating like the top equity chart?

I hope you can see where or what needs fixing in the formulas, as this is above me.

I' really am not sure why it won't work.

Again many thanks for your help with this.
All the best
The Ghost