Analysing and visualising a large dataset to make it meaningful

[daveyj66]

I have a spreadsheet that has a series of variables that "predict" when my retirement 'pot' will run out.

I've written some VBA code that adjusts the variables in turn and records the result in an array and then dumps that to a worksheet as raw data.

What I am now looking for is a way to graphically represent the data in a way that makes it meaningful to the lay user. i.e. which of the variables is the most important when changing? are there any hidden interdependencies of variables that I can?t see by looking at the raw data, such as if the tax rate changes a little bit more than expected what impact does inflation have?

What I have come up with is a Pivot Table and chart (Surface) as per the attached with sample data. The most important factors are ?Growth? and ?Income? so these are my Rows and Columns and the Years for the money to run out are the Values. I?ve used Average which is not ideal as the MIN and MAX can be very different depending on the other variables values.

My real data is at least 50k rows and can be 350k rows for a full sample.

Any ideas of a good way to analyse and report/represent/interpret the data better than what I have got?

Any thoughts hugely appreciated as this is a real world scenario and I am trying to work out if I can retire to spend more time with my wife who is undergoing cancer treatment.

Many thanks

Jonathan