Horizontal Bar Chart - Dynamic?

Many thanks for your reply Teylyn.
Sorry for my late reply, had major electrical problems,, sorted now, needed new wall sockets!

Regarding your uploaded spreadsheet.
I just can't get it working Teylyn I'm afraid. I can't get the chart or all data to update.
I've attached a screen capture, showing various options I'm seeing regarding excel and options. (The link problem)

Is the chart some kind of saved template Teylyn? Where it's looking for info on your HD and so I it won't work properly when you send?
(That's just a guess, but best I can think of).

I've attached another sheet Teylyn, MCE7. There is no chart in it.
Is it possible you can just alter Column N(WIN Column) & Column O, as these 2 are meant to update? Is this right Teylyn?

It's just that in all the sheets I have ,, none off these columns update.
I just can't see why not.

If I can just get all the data working 1st, then I can look at the chart.
(The chart is another issue Teylyn as I did have problems formatting, but I won't go into that now, so as to keep this email short,, but if you could kindly just show me what is needed in Col N & O so these update correctly.
Column K (Count) & L (Position) are working fine.

I just can't see what I've done wrong/or what is missing.

I attach now
Again many thanks for your help with all this, it is very much appreciated.
Many Thanks
TheGhost