Macro or function to graphically map out cell precedents?

Hello community members,

I am using Excel 2003 (and have access to Excel 2007 too) and would like to to graphically map out the precedents of a cell and make a flow chart of the data paths used in the calculation of this cell -- preferably in a separate Excel worksheet.

My initial thought was to use the "Trace Precedents" function within Excel but this proved to be too messy and difficult to transfer to a chart for my presentation. Also, the precedents of this cell use data from other worksheets within my workbook which also negate the "Trace Precedents" functions because a line trace will not follow data from another worksheet....

I have attached the Excel file I am working with. The cell I am referring to is C304 in the "Valuation BEZ" worksheet.

Any ideas or help will be greatly appreciated! Much thanks,

Nick