Multi-color Data bar with REPT function
In this article, we have created multi-color Data bar with REPT function in Excel. We have used the conditional formatting to change the color based on certain criteria. Multi-color Data
Tag: Chart and Visualization
Sales Analysis Heat Map by Time and Day
In this article, we have created a dynamic Sales Analysis Heat Map by Time and Day. Using this analysis, you will get to know your most busy time in a
Double Doughnut Chart in Excel
In this article, you will learn how to create a Double Doughnut Chart in Excel. In the outer layer of doughnut, we are displaying the Days name and in the
Progress Bar Chart in Excel
Progress Bar Chart in Excel Progress Bar Chart in Excel is very useful chart to show the completion% or other % metrics. In this example, we have displayed the Service
Dynamic Circle Chart in Excel
In this article, we have created Dynamic Circle Chart in Excel. We have used Bubble Charts to create this dynamic chart. You can use this chart in your Presentation. Dynamic
Pie of Pie Chart in Excel
Pie of Pie Chart is useful once data have 3 to 4 big slices in the Pie chart and multiple small slices. We can group small slices as one slice "Other"
Time Series Forecast and Anomaly Detection in Power BI
In this article, we have created the Time Series Forecast and Anomaly Detection in Microsoft Power BI. You can use this for Data Analysis, Sales Forecast, find Outliers in your
Cross Filter Functionality in Excel Chart
Excel is a powerful tool that provides a wide range of features to help you analyze and present data effectively. One of the most key features in Excel is the
3 Useful Tips for the Pivot Chart
In this article, you will learn 3 useful tips for the Pivot Chart. Using these tips you can create an interactive Excel Dashboard. Learn and download interactive Excel Dashboard free
Dynamic Comparison Analysis Chart in Excel
In this article, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other all employees