Comments on: Win Lose Charts – English Premier League 2007 – 2008

By: Brian Davis

Brian Davis — Tue, 05 Feb 2019 18:42:00 +0000

is there a website that already has a bump chart for EPL standings

By: jeffrey weir

jeffrey weir — Mon, 08 Jun 2009 10:01:13 +0000

I like your paramlink formula, but here’s a way to accomplish nearly the same thing without it.

I’ve got a row of form optionbuttons sitting over each of the last plotted points in a bumps chart – one for each series. All these series are formatted gray, with nice big round line markers tthe same size as my optionbuttons. Then I’ve got a red series that points to a dynamic range courtesy of the optionbutton value being used in an offset function. The result is that the user clicks on the last datapoint of a particular series of interest, and that series turns red on account of the dynamic graph series range. Almost exactly the same as what your cool function does, but without additional addin.

Only problem is that my optionbuttons are visible, which only slightly spoils the ‘magic’ of this effect. What’s more of a problem in this partitular case is that they get in the way when I collapse a grouping that this chart is sitting in. The chart is snapped to a cell so that it completely dissapears courtesy of a ‘group and outline’ group (which is a handy way to get rid of a chart from a dashboard report when you don’t want to see it) but the option buttons seem to behave differently…they don’t dissapear along with the chart even though they are snapped to the same cell. Instead they obscure some text.

So I either need to find out how to make the optionbuttons transparent, or I need a macro that will ron a ActiveSheet.Shapes(“Option Button 33”).Visible = False routine when I collapse the particular row that the graph is in, and that will also make them visible when I expand that particular grouping.

Any help greatly appreciated.

Love your posts, and cant wait to get my entry in to the dashboard comp…I’ve got some other cool tricks that I’m sure you will digg.

By: Paul

Paul — Sat, 04 Oct 2008 21:13:13 +0000

Hi,
Very interesting page. I had only looked at the first table, and it took me 5 minutes to figure out that the last 8 result portion of the table was going in the wrong direction.
Your revised table is very revealing, but from a graphical consideration I would suggest the following:
01. The Win Loose section suffers from the bars representing a draw being too small. You might want to consider slightly decreasing the bars for W and L and increasing the height of the bar for a draw. Improved contrast between the three (or colour) would also help.
02. The continuous line representing position over the season only illustrates the team’s performance relative to itself. For instance the highest point on Derby Co’s line is actually approximately equal to the lowest point on Chelsea’s line. Without considering the numerical data there is no way of determining this. These graphs therefore allow no inter comparison between teams. It is therefore suggested that these graphs, which consume a large portion of the table, is of comparitively limited value.
03 I see no advantage of seperating the numerical data regarding WLD to the extreme right of the table. I suggest that a more logical structure would be to place the WLT data to the right of the GDiff column, folowed by the (ammended) Win Loose Diagrams and then the max and min positions followed at the end by the position diagram.

Hope this is of assistance,

Regards,

Paul

By: Kingsley ani

Kingsley ani — Sun, 14 Sep 2008 05:21:49 +0000

Chelsea is the best club in premieship,but i think the should allow the striker franco di santo to prove him self,they go for another striker.

By: Interactive English League Bumps Chart | More Information per Pixel

Interactive English League Bumps Chart | More Information per Pixel — Mon, 18 Aug 2008 05:51:21 +0000

[…] here, you may want to subscribe to my RSS feed. Thanks for visiting!This bumps chart shows you the English Premier League 2007 – 2008. It allows you to highlight and compare two teams by clicking a team in in the table or a line in […]

By: Ian Waring

Ian Waring — Sat, 19 Jul 2008 10:53:59 +0000

The only thing that threw me on the “Bumps” chart is that Manchester United play in Red, and Chelsea in Blue – whereas you’ve colored them the other way around ;-}

Ian W.

By: Andreas

Andreas — Wed, 02 Jul 2008 17:06:45 +0000

Jon,

We plan to support Firefox in a later release of the WebEdition.

Seth Godin seems to have the explanation why most of our blog visitors are on Firefox

http://sethgodin.typepad.com/seths_blog/2008/04/why-downloading.html

Andreas

By: Jon Peltier

Jon Peltier — Tue, 01 Jul 2008 15:30:00 +0000

Error when clicking “Interactive Bumps Chart” link:

“To run Excel Web Edition worksheets you need to have have Microsoft Internet Explorer 5.5 or higher installed.”

I thought everyone used FireFox.

Anyway, this chart type can be reproduced in a non-web version of Excel:
http://peltiertech.com/Excel/Charts/ParallelCoord.html