Series overlap

When analyzing sales, we will often come across data series that would be convenient to display using a Stacked Column or Stacked Bar chart, but due to their nature this is not a good solution. For example, if we have a production cost and a sales price, we need to calculate the price difference in order to show the production price and the price difference as two complementary series on the chart; their sum is, it is easy to see, the sales price. Can we create such chart without additional calculation?

Stop If True option

When defining conditional formatting rules, sometimes there are more than one format, and we want one formatting rule to exclude another. In these situations, Stop If True option may be helpful. It is used in various ways, and one of the simplest is filtering the conditional formatting rules given by icon sets. Let’s see how this works!

INTERCEPT

For a given series we can add a trend line which, by applying the selected mathematical function, approximates and shows the trend of data, which was discussed in one of the earlier posts. By displaying the value of R2 we can see how well we chose the function that approximates the data. How else can you improve the trend line appearance?

Ideas

Power BI has for some time been equipped with feature that enables it to analyze data, and then on the basis of them it is proposed to create appropriate visuals. From recent time such option exists in Excel, and for the time being it can only be used by Office 365 subscribers. This option is called Ideas. Let’s look at how Excel can offer you clues to help you get the most out of your data!

Mekko chart

Mekko chart is a type of Stacked Column chart where columns are expanded in such a way that series are merged, so it’s an excellent choice to show sales through market segments. In most cases, we will use 100% Stacked Column, and there is also a subspecies of this chart called a ridge, which is actually a Stacked Column with a peak emphasized by a bold line to emphasize the trends …