graphically display calculations in excel

[GraphicalGuy]

The layout of complicated Excel spreadsheets can make them difficult to
analyse for logical structure and consistency.

What would be really useful would be a graphical user interface for excel
spreadsheets, along the same lines as that used in Clementine software.

So different columns of data could simply be displayed as “data itemsâ€, each
one connected to the others graphically by arrows. These arrows could
symbolise the relationship between the different data items, or operations
being performed to get from one to the next.

In this way, you could “visualise†the flow of calculations in an Excel
spreadsheet, and therefore spot the errors.

Do you know of any such software already in existence that performs this
function?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d-eb4db98a20b7&dg=microsoft.public.excel.misc

 

[David Biddulph]

Have you tried Tools/ Formula Auditing ?

 

[Jan Karel Pieterse]

Hi GraphicalGuy,

Do you know of any such software already in existence that performs this
function?

First of all there are the formula auditing options built into Excel you
can use that already do that in part.

I have built a reference utility that visualises all dependents and
precedents of a cell (up to a selective number of levels) in a treeview
like manner (like the folder list in explorer).

Contact me through my site if you're interested.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com