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