Gantt chart s a chart type used to track project realization through phases, so we can see when the activity starts, how long it takes and when it finishes. It does not exist as a standard chart, but it can be created by modifying the Bar chart. In the following text, step by step, you will be able to find out how to create such report.
In one of the previous “recipes” you could find out how to calculate the number of past days between two dates. Excel has another function that can be used for this purpose. It is a hidden DATEDIF function, which, for two given dates, can calculate the number of years, months or days. The following text will be about how this function is used …
In one of the earlier texts there were words on how to take advantage of the secondary axes to display disproportionate data series. The common problem here is the overlapping of the series. Therefore, the data is not sufficiently noticeable. By adjusting the width and gap between the series it can be slightly corrected. However, in order to make the data on the graph more noticeable, one can use a trick that will be described in the following text …
With Protect Sheet and Protect Workbook, a user can protect a worksheet or workbook so that only a person who knows the correct password can access them. However, what if we want to protect only part of the worksheet? Also, if more than one user is simultaneously working on the document, is it possible to grant them different access rights? Can the system administrator use domain rights for this purpose? Meet the Allow Users to Edit Ranges option.
In addition to my passion for Excel my great love, and partly my job, is Customer Relationship Management (CRM). One of the most important CRM charts for tracking sales is the Sales funnel. Every salesman likes to see it on his dashboard at the beginning of working day, because with one look he can conclude whether the sale is standing or advancing. Funnel does not exist as a standard chart. It is created by modifying the 3D Column chart, and how to do it you will find out in the text that follows …