The simplest way to modify Excel charts and add new elements is by using the menu displayed in their upper right corner. Based on this functionality, Power BI received an option for modifying and formatting visualizations, which is called on-object interaction. It enables easy addition, modification and removal of report dimensions and other display elements, as well as customization of the appearance of the visual…
When we make charts in most cases we’ll use text labels, numbers, dates, percentages etc. to display categories on the x axis. Sometimes descriptions are too long, so we have to work in different ways to display them in an adequate manner. Could we use something that describes them more closely such as a currency symbol, an envelope, a smiley face? In this “recipe” you will learn how to add different symbols to a table or chart.
Calculated Items allow you to create formulas based on arithmetic operations between elements in rows and/or columns within a pivot table. Sometimes Excel can get confused and display incorrect results due to a misinterpretation of the order of computational operations. Solve order is an option with which we can change the order to get the correct result.
Box & Whisker charts are used for a statistical analysis of the data set. They come along with Excel 2016, and serve to show the statistical distribution of data according to quartiles, emphasizing the mean, maximum and minimum values. In business, they can be used, for example, to analyze the turnover of an item byclass or sales group. Then we analyze the value distribution, based on which we can make conclusions about future values.
Sunburst is another new chart brought to us with Excel 2016. It is suitable for displaying sales values (traffic, earnings, merchandise, etc.) according to periods, arranged by hierarchies such as: years, quarters, months, days … It reminiscent of a Doughnut Chart, because the width of the ring shows the value that we want to present. It differs in showing several rings, each corresponding to one of the hierarchies.