Horizontal Bar Chart - Dynamic?

**teylyn** · 09-20-2009, 08:35 PM

Hi,

I fixed the chart so it now shows the percentage labels. Hope you can see it.
Also, the chart was not pointing to the win/loss data. I fixed that, too.

Whenever I hit F9, the numbers update and the chart changes.

I noticed that you have entered the sumproduct formulae in the win/loss table with CTRL-SHIFT-ENTER. There is really no need to enter them as array formulae. I'm not even sure if that is a good thing, but I don't know much about them.

Apart from the chart, I can't help you much further, I'm afraid, because I don't really understand what the spreadsheet does.

But you seem to have a good grip on it now.

cheers

**theghost** · 09-23-2009, 06:13 PM

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