Not suitable for limited time products

sasob91342

As mentioned above, creating a Z-chart requires more than two years of data. Therefore, it has the disadvantage that it is not suitable for analyzing sales of products that are available for a limited time, such as seasonal products. For products where the freshness of information is important, such as those where data needs to be collected and analyzed immediately after sales, it is better to use another method. Three views from the Z chart type As mentioned earlier, reading the Z chart is quite easy. You can easily see changes in sales by checking the rise and fall of the upper right corner of the "Z". Depending on the shape of this “Z”, charts can be divided into three types.


From here, let's take a look at each type and what you can learn from them. 1: Rising to the right (growth type) The top right corner of the "Z" letter is facing upwards, making it a type that rises to the right. This indicates that sales have Iraq WhatsApp Number Data increased from the previous year, and can be described as a "growth type." If there is significant growth, you can find opportunities to connect to the next one by investigating the factors behind the growth, such as the presence or absence of events during the period. 2: Downward slope (declining type) It is a type with the upper right corner of the "Z" letter facing downwards, with the right shoulder sloping down.



This can be described as a ``decline type'' where sales are down from the previous year. Sales itself is also trending at a low level in the graph, so it is better to come up with a solution quickly. 3: Horizontal (flat type) The moving annual graph at the top of the "Z" shape is almost flat, and the bend at the top right is also a horizontal type whose height is almost the same as the starting point. This can be described as a ``flat pattern,'' which maintains the current situation compared to the previous year. The cumulative graph has a nice "Z" shape and is almost a straight line, indicating that sales are constant. 4 steps to create a Z chart in Excel.