LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Joa Joa is offline
external usenet poster
 
Posts: 1
Default converting a spreadsheet to graphical representation

We have huge assemblies of parts that are broken down into assemblies,
subassemblies, installations, etc. These are in big parts lists.

Currently we have another worksheet that just has boxes drawn with
connectors between them to create a "parts tree" graphical
representation. This is completely manual and every time the parts
list changes the tree has to be manually updated.

Is there an add-on or another piece of software that would do this for
us automatically???? We could set the hierarchy up in the parts list
and use it to set the grouping in the graphical version (A, A1, A1A,
etc).

Thanks!

Joa
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to change scientific representation Farooq Sheri Excel Discussion (Misc queries) 1 October 20th 09 01:52 PM
color representation of employee work hrs Sri New Users to Excel 4 June 23rd 08 01:22 PM
Multiple Data Representation on Graphs Hem13P Excel Discussion (Misc queries) 0 September 14th 06 09:44 AM
Automatic representation of cell values Venkatesh V Excel Discussion (Misc queries) 2 March 22nd 06 03:40 AM
Graphical Representation cityinday Excel Discussion (Misc queries) 4 March 19th 06 04:44 AM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"