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
This time I am back with a beautiful 3D container Pivot Chart with the slicers and Timeline. We have displayed the sales conversion by Zone on the chart. We have used multiple calculated field in the Pivot table to create this chart. Below are the data points which we have used to create this chart- [caption id="attachment_13130" align="aligncenter" width="670"] Data Table[/caption] Below is pivot table which we have created to
3D Filled Pyramid chart have been designed to display the KPI metrics like Sales Conversion, Service Level or any other KPI in percentage. You can display multiple categories on horizontal axis like we have displayed 4 different Zones – EAST, WEST, NORTH and SOUTH. We have used gradient fill for each zone which makes it more attractive. Below is the data set for 3D pyramid Chart- [caption id="attachment_13056" align="aligncenter" width="407"]
In this article you will learn how to create dynamic Sales Funnel Chart with Slicers. This Chart can be used in your business dashboard or presentations. Below are the data points which we have used to create this chart- [caption id="attachment_12910" align="aligncenter" width="603"] Data Point for Chart[/caption] Below are the steps to create this beautiful Chart- Create a pivot table using this data and move Identify, Validated, Qualified, Proposal and
3D Disk Pie Chart is basically a 3D Pie Chart. We have changed the 3-D Format to make it eye catching Chart. It can be used in business dashboard or business presentation. We have created this for Day wise sales. Below is the data set. [caption id="attachment_11582" align="aligncenter" width="261"] Day wise sales data[/caption] Below is the snapshot of Disk Pie Chart- [caption id="attachment_11583" align="aligncenter" width="1625"] Disk Pie Chart[/caption] Click
I am back with one more innovative chart which is a Stunning Thermometer Chart. This chart can be used for display KPI metrics. You can display your data by category also like Zone Wise or Month wise etc. We have created it for Zone wise service level. [caption id="attachment_11261" align="aligncenter" width="277"] Zone Wise Data[/caption] Below is the snapshot of Stunning Thermometer Chart [caption id="attachment_11263" align="aligncenter" width="599"] Stunning Thermometer Chart[/caption]
While creating a dashboard, many times it happens when you don’t have the sufficient space to place your multiple chart. You can create the small charts to display your weekly performances. These charts are very small but readable. Below is the data set for which we have created these small charts. [caption id="attachment_11139" align="aligncenter" width="174"] Small Charts for Weekly Performance[/caption] Below are the Weekly Charts available. We created these
Stylish Circle Chart has been designed to display the KPI metric. It can make your dashboard more attractive. We have used Pie Chart and Oval shape to create this Chart. [caption id="attachment_11019" align="aligncenter" width="700"] Stylish Circle Chart[/caption] Click here to download this Chart
Rather than showing the simple numbers , you can display some symbols in your Excel table. Here we have taken an example of Employee Rating Table for 1 to 5. We have used Conditional Formatting with Icon set to create this Employee rating table. You will select the rating using drop-down and it will be changed in symbol automatically. [caption id="attachment_10772" align="aligncenter" width="783"] Employee Rating Table[/caption] Click here to
In this article you will learn a trick to resize and relocate a chart using VBA. We have created a shortcut key Shift+Ctrl+R to resize and relocate active chart. You just need to select the range and your selected chart will be relocated and resized according to selected range. You can move the chart to another worksheet also. Below is the VBA Code- Sub Resize_Chart() Dim cht As Chart On
