Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphically display calculations in excel
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/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphically display calculations in excel
Have you tried Tools/ Formula Auditing ?
-- David Biddulph "GraphicalGuy" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
graphically display calculations in excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: date display issue | Excel Discussion (Misc queries) | |||
To display contents of a folder in an excel sheet using Excel MACRO | Excel Worksheet Functions | |||
How do I set up the remainder to display in Excel? | Excel Discussion (Misc queries) | |||
Excel worksheet display #### | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) |