When analyzing key performance indicators (KPIs) for their display is often used a gauge that resembles a speedometer in a car. This is not a standard Excel chart. There are commercial add-ins used to create this type of chart that could be found on the Internet, but there is a technique to create it by combining and modifying the existing charts of Doughnut and Pie Chart.
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 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 …
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 …
Flowchart diagrams can be made manually, by embedding and connecting different shapes. Also, we can make them based on some of the templates that come with Excel, and it belongs to the SmartArt schema group. SmartArt schemes are nothing more than diagram templates, created by creating and grouping objects. If you are well acquainted with them, they can greatly facilitate your work and shorten the time when making a diagram.