Dynamic Graph with Camera
In this article, we have created a dynamic graph with Camera functionality of Excel. We have used conditional formatting in Chart. You can change the chart type using Form Control
Charts and Visualization
In this category, you will find comprehensive tutorials on creating stunning charts and visualizations in Excel. Impress your colleagues and boss with attractive and informative visuals by following our step-by-step guides. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the process. Explore this category now and enhance your data analysis and presentation skills with Excel.
Conditional formatting in Excel Chart
In this article, you will learn how to use Conditional formatting in Excel Chart. You can use this trick to show to Target Vs Actual number. Conditional formatting in Excel
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
Beer Mug Graph in excel
Beer mug chart is a beautiful infographic representation for KPI metrics in percentage like - Target Achieved%, Service Level%, Quality Score etc. Beer Mug Graph in excel [caption id="attachment_56543"
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"
Conditional Formatting in a Pivot Table with 3 Example
Conditional formatting in a Pivot Table is a very useful feature in Microsoft Excel. If you are working on an Excel Report or Excel Dashboard then often require conditional formatting
Stylish Column Chart in Excel
In this article, we have created a Stylish Column Chart in Microsoft Excel. You can use this info-graphic chart in your Excel Report or Business Dashboard. We have displayed Day