The project provides an Excel VBA macro to create a chart with data extracted from Excel worksheets.
Within the demo folder you can download an Excel demo document that can help understanding the functionality and the ability of the macro.
The Excel document needs to match the following structure:
The element is non optional and needs to be declared for every row in the worksheet. The element could be any data like e.g. the name of an employee (or a task, a software module, …).
If your elements are not unique itself, you can use the optional section to build a unique key. This key is used to identify the correct element. In my example, the section could be the bureau or department of the employee (or a project). (Hint: So far, the macro assumes there is a section. If you don’t use a section, the created chart will add empty lines instead -> not looking nicely. To fix this just fill a column with any short string and use this as the section for every element.)
Your element might depend on other elements (or sub elements). The chart will show these dependencies and also searches for other elements that depend on the considered one. If there is some direct interference between different elements, the chart will show this as arrows between the elements. Taking my example, the employee could depend on its team or some equipment (or depending tasks, software sub modules / functions, …).
The keys are created by combining the optional section, a selectable delimiter (see CONFIG) and the element. The key should be unique, because in case it is not, the macro will only consider the first matching key, ignoring every other match.
By just inserting the 3 vba code files into one (or more) macro modules of your Excel document, you can use the macro. Please save, close and reopen your Excel document afterwards to let the auto start macro do its job.
If you first use the macro on your own data you need to adjust some settings. Therefore please read through the CONFIG file and adjust the parameters to meet your data. Especially the “Processed Columns” section need to be adjusted. After adjusting the CONFIG it is recommended to save, close and reopen the Excel document to let the Auto_Open function do its preparation.