Excel 2019 has got a new type of maps that we can use to illustrate the data from the spreadsheets we’ve made. Actually, this is just another chart that we can add from Insert ribbon or after launching the Recommended Charts option. It allows us to create filled maps, where each country from the given dataset is filled by a color according to given values.
Purpose of PowerBI Desktop application is to create reports on a local machine and publish them in the cloud for users who can see them anytime, at any moment, by Internet browser on a PC or a mobile device. Managers need to get clear, simple and visually nice reports. It seems that PowerBI meets all given criteria. In a text that follows I will describe various ways to create reports in PowerBI Desktop.
There is a time of Christmas holidays, the time when everybody, more or less, decorates the Christmas tree, and this served as an inspiration for the text on the application of one more type of Excel chart. It is a subtype of the Scatter called Bubble and by which we can get a “XY” chart whereby a multicolored “balls” are found on the section. To create this diagram all we need are: a table of data, a picture of the Christmas tree and a little work in Excel!
o far, in several “recipes,” you can find out how to create and beautify the charts. This one will be about how to combine charts and images. First, in the case of a simple column column, you will see how to replace the columns with the image. Then we will add the picture as a background. Although it will not be about new features here, using some tricks will help you to make your reports more beautiful.
When I was in school, and learning about Cartesian (Descartes’s) coordinate system I must admit I liked it a lot! I was in love with the idea that in the intersection of x and y axes, dots can be drawn, and then they connect to the line and show some trend. It’s been a long time since than, and in the honor of legendary Rene Descartes I’ll be creating a recipe about scatter charts.