This week we will create a dynamic graph that shows the changing costs for each region over the years. The key element of this graph is to create an additional series for the region in focus, which changes when the user selects a different region. Output 2 The graph is in the Output 2 tab on the Excel workbook here, members can access the Read more [...]

Hi again. Last week we prepared the first output report from our sample data. You will recall that the engine for the output is in the ‘set up’ tab and is repeated below. Cells D2 through to D17 is the table of years I created. Cell D1 is linked to the year chosen in Output 1, in the above example this is the 13th item Read more [...]

In this week’s blog we will be looking at an example using a downloadable, interactive spreadsheet filled with real data.   Readers, please click here to download the locked spread sheet. Lounge members, you can download the unprotected spread sheet from within the lounge.   Example Data Most of the data I use is Read more [...]

  Hi there ……… so you’re interested in analysis? What’s your specialist subject? I’m guessing a sport – rugby, football or hockey perhaps? But of course you could equally be in banking, property or perhaps in sales? Either way I bet you will probably have a pile of data on your subject, so much so that you don’t Read more [...]