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
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. We have created this stunning visual using Excel Shapes and Pie Chart. Click here to download practice file- Watch the step by step video tutorial:
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
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
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
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
In this article, we have created a Forecast Vs Actual Chart with Safe Zone Range. This is a very informative chart wherein you can display that your actual numbers are within the forecast range or not. We have below given data to create this chart- [caption id="attachment_15854" align="aligncenter" width="377"] Actual and Forecast data[/caption] We have created a below given chart where we have displayed – Forecast, Actual and Safe Zone
In our last article, we created a Dynamic Chart with Slicer for Employees Count by Age group. Now in this article, we have created same chart with Form Control Option buttons rather than Slicer. We have created option buttons for departments. Whichever option button will be selected, it will display the data on the chart accordingly and Chart title also will be changed. Below is the data for multiple employees
In this article, we have created a Pivot Chart to display the department wise employees count by different age groups. We have given a slicer for departments. Whichever department will be selected in the slicer, it will display the data on the chart accordingly and Chart title also will be changed. Below is the data for multiple employees with their age in years- [caption id="attachment_15419" align="aligncenter" width="467"] Employees Data[/caption] Below
We have created an attractive visualization to display multiple KPI performance in Excel. We have used Excel auto shapes to create this visualization. RAG (Red, Amber, and Green) color changes dynamically to display the KPI performance. This visualization can be used for any type of KPI data type like – Numbers, percentages or decimals etc. We have displayed below given sample KPIs on the visualization - [caption id="attachment_15053" align="aligncenter" width="194"]
