Line Chart with RAG Background
Charts and Visualization

RAG (Red, Amber and Green) Analysis Chart in Excel

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
User Interface Protection
VBA

Protect Excel Worksheet as UserInterFaceOnly

Just assume you a worksheet wherein you have few groups for column or rows and then you protected that worksheet. Now will you be able to expand or collapse those groups? No, you cannot expand or collapse it because it will show error as worksheet is protected. [caption id="attachment_13217" align="aligncenter" width="1166"] How to expand or collapse group while worksheet is protected[/caption]   If your worksheet is protected and you want
3D Container Chart
Charts and Visualization

3D Container Pivot Chart with Slicer and Timeline

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 Pyramid Chart
Charts and Visualization

3D Filled Pyramids Chart in Excel

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"]
Sales Funnel Chart
Charts and Visualization

Dynamic Sales Funnel Chart with Slicers

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
Custom Formatting
Excel Tips and Tricks

Arrows Symbols (➷➹) with Custom Formatting in Excel

Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down arrow (➷➹) for Variance %. We have a table for Market wise sales for Current Year and Previous Year. We have displayed Variance % here with designer arrows. [caption id="attachment_12838" align="aligncenter" width="617"] Market Wise Data[/caption] In the Variance % column we
Drillthrough
Power BI

Drill through in Power BI

In this article you will learn how use Drill through in Power BI. You can create a page in your report that focuses on a specific entity such as Supervisor or Employee. Users can right-click on a data point in other report pages. Then they can drill through to the focused page to get details that are filtered to that context. We have our main page wherein we have a supervisor wise
Tooltip in Power BI
Power BI

Customized Tooltip in Power BI

In this article you will learn how to customize Tooltip in Power BI and how to use a Report page as tooltip in Power BI, Tooltip is very useful feature available in Power BI. You can customize the tooltip like- background color, Font Name, Font Size, Font color etc. Below are the steps to customize a Default Tooltip: Select the visual and Go to Format Change the Label Color, Value
Highlight Unmatched Cells
Excel Tips and Tricks

Highlight Unmatched Cells using Conditional Formatting in Excel

In this article you will learn how to highlight the Unmatched Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the Sales worksheet we need to highlight the Products which are not available in Product Master. [caption id="attachment_12307" align="aligncenter" width="1496"] Sales Data and Product Master Worksheets[/caption] Below are the steps to put the Conditional Formatting to highlight Product Name in Sales
Highlight Consecutive Duplicates
Excel Tips and Tricks

Highlight the Consecutive Duplicates in Excel using Conditional Formatting

In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance Sheet. Let’s say we have month wise sales wherein we have month name duplicate. We want to highlight the consecutive duplicate month as given in below image [caption id="attachment_12290" align="aligncenter" width="282"] Consecutive duplicate month[/caption] Below are the steps to put