The Waterfall Chart is a report that is often used in controlling, and is ideal for displaying inflows and outflows of money over a given period of time. On this occasion, it usually shows the situation at the beginning and at the end of the period. Earlier it was done as a combination of two series of data, one of which was specially formatted in order to get the effect of the “waterfall”, and from the 2016 version it can be made directly from the Excel.
Waterfall Chart, also known as the Bridge Chart, is a convenient way to show the cumulative effect of the growth or decay of data in the initial and final set value. From the 2016 version this chart has become an integral part of Excel, but it can also be done by creating specific formatting of data series combinations. It can be said that this text will be about “Waterfall” chart for “users with cheaper tickets” …
Most of us are using Google Maps, but a few years ago Microsoft also went into the race and created its own version of the maps named after its Bing search engine. From Excel 2016 exists an add-in with the same name that you can use to display charts on maps. It allows you to display data, in a form of charts, positioned on maps that can be customized to the desired report layout.
In the previous “recipe” you could read about add-ins that you can download from the Office Store. One of them is called People Graph, and starting from the 2016 version, it’s a standard part of Excel. People Graph is convenient for showing charts that describe the results of a survey in which a population is being tested. It is used in a very simple way, and it enables the creation of picturesque reports.
Slicers are graphic objects that are used as an interactive filters for filtering reports in Pivot and Power Pivot reports. In combination with certain DAX functions they can be used for setting the parameters of the calculation. The following recipe will show you how to do a sales report in which, according to chosen exchange rate, you can see results in different currencies. To test a status of a slicer will be used function HASONEVALUE.