Drill Down/Drill Up Feature in Pivot Chart
In this article, we have created a Drill Down/Drill Up Feature functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are
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.
Sales Dashboard Power View in Excel 2013
Sales Dashboard Power View in Excel 2013 In this article, we have created a beautiful Sales Dashboard Power View in Excel 2013. [caption id="attachment_22871" align="aligncenter" width="964"] Power View in Excel[/caption]
5 Layered Advanced Doughnut Chart
5 Layered Advanced Doughnut Chart In this article, we have created the 5 Layered Doughnut Chart to display the KPI value up to 500%. We have created two different version
RAG waffle Chart visualization with Slicer
In this article, we have create a RAG waffle Chart visualization with slicer to display the Red, Amber and Green percentage. We have used Conditional Formatting and linked picture feature
Dynamic Performance Chart in Excel
In this article, we have created dynamic Performance Charts. We have used excel shapes and Doughnut Chart here. To make these charts dynamic we have used Form control option buttons. Dynamic
Data Driven 3D Table in Excel
In this article, we have designed a data driven 3D table in Excel. We have used Linked picture and excel shapes to create this table. You can use this in
Timer Chart Visualization in Excel
In this article, we have created a beautiful data driven Timer Chart visualization. You can use this chart to display KPI metrics like Service Level, Quality Score, Sales conversion etc.
Dynamic Conditional Formatting in Excel
In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights
Animated Speedometer Chart in Excel
In this article, we have created an Animated Speedometer Chart in Excel using Charts and VBA. This beautiful chart can be used in your business dashboard. An animation will run
Dynamic Variance Arrows Chart with Slicers
In the previous article we create a Dynamic Chart with Variance Arrows using multiple check boxes. In this article, we have created the similar Dynamic Variance Arrows Chart with Slicers.