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"]
In our previous article we created a Vertical Timeline Chart using Scatter chart. Here, we have created a Horizontal Timeline Chart using scatter chart in Excel. This is a dynamic chart. if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Horizontal Timeline Chart in Excel- [caption id="attachment_14872" align="aligncenter" width="1215"] Horizontal Timeline Chart[/caption] Click here to download the
A timeline chart is an effective way to visualize the different Milestones of a Project. Here we have created a Vertical Timeline Chart using Scatter Chart in Excel. This is a dynamic Chart if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Vertical Timeline Chart in Excel- [caption id="attachment_14813" align="aligncenter" width="992"] Vertical Timeline Chart[/caption] Click here
The Waffle Chart is an attractive 10x10 grid in which each cell represents one percentage point. You can use this chart to display your KPI metrics like Service Level %, Quality Score %, Sales conversion % or Project completion%. Here we have created 3 different Waffle Charts to display Service Level %, Quality Score %, Sales conversion% in Microsoft Excel. [caption id="attachment_14747" align="aligncenter" width="1140"] Waffle Charts in Excel[/caption] Click here
This is the second part of Spotlight visualization. Here we have used spotlight to highlight top performer in the chart. We have created a Column Chart for Team Manager wise sales and highlighted the team manager with the highest sales. Below is the data which we have used in this chart- [caption id="attachment_14259" align="aligncenter" width="609"] Data[/caption] We have created this chart in 2 variants. Below is the snapshot to variant-1.
This is the first part of Spotlight visualization. Here we have used RAG (Red, Amber and Green) color code to display metric performance like – Service Level, Quality Score and Sales conversion. To create these stoplights, we have used Excel shapes and to change the color dynamically we have used Name Manager and Linked Picture here. Below is the data for which we have created these spotlights- [caption id="attachment_14253" align="aligncenter"
You can create very attracting info-graphics with the help of Auto shapes. Here we are giving an example of this. We have created stylish and beautiful Traffic lights info-graphics using Auto Shapes and Conditional Formatting in Excel. You can use these traffic lights in your Business Dashboard or Project Management Dashboard to display project health. Below is the data set which we have used to create these Stylish Traffic Lights-
We are back with one more stylish chart but this time we have used a pivot chart and connected it with a slicer. We have displayed employee wise sales on this chart with Day slicer. You can see the data for any specific day using slicer. We have also changed the slicer style slightly. Below is the data table for which we have created this pivot chart. [caption id="attachment_13533" align="aligncenter"
RAG (Red, Amber and Green) Analysis Chart is very useful to analyze the performance. We have designed this chart using Stacked column chart and Line chart. You can change the background color range by just changing numbers on excel. Below is the data set which we have used for this chart. We have taken 3 support columns here. [caption id="attachment_13295" align="aligncenter" width="455"] Data set for chart[/caption] Below is the snapshot