Forum

Thanks Sunny - the VBA solution is neat... and impressive. Trying to write logical formulae to do the same thing was doing my head in and taking a ...

Thanks Mynda - that is an interesting work-around, and yes 2014 and 2016 were 'good' years. However, the trend of the accident frequency is also im...

Thanks Anders, I followed your advice so can now answer my own question... so in case of use to any others using Pivot Tables in different language...

Mynda, Thanks for the prompt reply. It is strange as I had the same issue on different PCs and with Excel 2010 and 2016, but building the chart ...