I am trying to 'graph' various traffic data in excel.
Unfortunately I cannot post all of my workbook as it is over 10mb. I even had to disconnect the sheet with pivot tables and 'ultimately' the graph I am trying to achieve. (I have attached a screenshot to try and show pivot tables and chart etc)

My data source is a text file which I import and is usually around 120,000 rows, which can take forever to 'calculate'.

Richard Buttery very kindly offered me a solution to an issue I was having generating 85th percentile data in my chart (Richards work is highlighted in yellow).

However, having done some research it seems that using COUNTIF(S) on a large amount can have performance issues (people seem to be annoyed at 15-20 seconds) so an hour seems a tad excessive and I'm not convinced that this is the root cause of my issues.

Clearly there is something not right with the way I have constructed my 'report'.

dynamic traffic chart.xlsxChart Sheet.JPG

Wonder if anyone can give performance optimising advice?

Many thanks