Category: Excel DataViz
Create star rating in Excel or Power BI using DAX
Here is a simple solution to create a five star rating in Excel using formulas or Power BI using DAX. The result is obtainable using only Excel formulas or DAX capabilities. You can do that with other symbols or emojis too. With the same techniques, it is possible to create a progress bar in Excel…
Jitter chart in Excel with average line
A jitter chart in Excel is a beautiful way to use a scatterplot and randomly distribute data points to make them more visible. In other words, if your problem is overlapping data points in Excel, this might be a good solution.