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 …

Population pyramid chart

Population pyramid is a subclass of the Bar chart chart that is conenient when we need to show results of the research in which we compare two populations. Most often we compare the percentage representation. These can be answers, in relation to the age, how many survey members responded with the “YES” and how many with “NO”, we can compare the number of men and women which belong to a certain population, etc.