3D Table in Excel
Charts and Visualization

Data Driven 3D Table in Excel

In this article, we have designed a data driven 3D table. We have used Linked picture and excel shapes to create this table. You can use this in your business presentation or business dashboard. We have used Conditional Formatting to display the icon set. Below is the snapshot of 3D Table- [caption id="attachment_19434" align="aligncenter" width="1365"] 3D Table in Excel[/caption] Click here to download this practice file.   Watch the step
Dynamic Conditional Formatting
Charts and Visualization

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 according to the selection of Option button. While selecting the Heat Map option button- [caption id="attachment_19032" align="aligncenter" width="776"] Heat Map Conditional Formatting[/caption] While selecting the Data Bar option button- [caption id="attachment_19033" align="aligncenter" width="774"] Data Bar Conditional Formatting[/caption] While selecting the
Animated Speedometer
Charts and Visualization

Animated Speedometer Chart in Excel

In this article, we have created an Animated Speedometer Chart using Excel Charts and VBA. This beautiful chart can be used in your business dashboard. An animation will run when the value of service level will be changed, or worksheet will be activated. Below is the snapshot for Animated Speedometer Chart- [caption id="attachment_17070" align="aligncenter" width="1253"] Animated Speedometer Chart[/caption] Below is the code to run this animation- Option Explicit Private Sub
Dynamic Variance Arrow Chart with Slicer
Charts and Visualization

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 Chart with Variance Arrows using Slicer. This is quite useful chart to display the Sales variance in compare of previous year. We have used green and red arrow to display the percentage change. You can select multiple market in slicers using Ctrl + Click. Below
Dynamic Variance Arrows Chart with Check Boxes
Charts and Visualization

Dynamic Variance Arrows Chart with Check Boxes

In this article, we have created a Dynamic Chart with Variance Arrows using multiple check boxes. This is quite useful chart to display the Sale variance in compare of previous year. We have used green and red arrow to display the percentage change. This is a dynamic chart. if you will check any market name check box, data will be changed automatically on the chart. Below is the data for
Group of Circle Charts
Charts and Visualization

Group of Circle Charts in Excel

Using the multiple Doughnut charts, we have created a beautiful Group of circle charts. In this Group of Circle Charts, we have displayed Market level and Over all service level. You can use it in your business dashboard or presentation. Below are the data points for which we have created this Group of Circle charts – [caption id="attachment_16550" align="aligncenter" width="262"] Data Set[/caption] Below is the snapshot of Group of Circle
Dynamic Chart with Scroller
Charts and Visualization

Dynamic Chart with Form Control Scrollbar

In this article, we have created a Dynamic Chart with Form Control Scrollbar. If we have multiple dates in your data, then we can use scrollbar on the chart to display rolling 10 days or 15 days data points at a time. We have used below given data to create this dynamic chart – [caption id="attachment_16355" align="aligncenter" width="439"] Data point to create dynamic Chart[/caption] Below is the dynamic chart with
Word Cloud
Charts and Visualization

Word Cloud in Excel Using VBA

Word Cloud is also known as text cloud or tag cloud. Size of the words change according to the value or weightage or frequency of any word. Here we have created a macro to create the word cloud in Excel. In this macro file, we have 2 worksheets Setting Worksheet – In this worksheet, you need to enter your data, like we have entered the Country wise population. We have