We have started the Microsoft Power Point Charts and visualization tutorial. Here we have created a data driven Target Vs Actual Sales chart with animation. You can use this Chart with your data. [caption id="attachment_17492" align="aligncenter" width="685"] Target Vs Actual Sales Chart in PPT[/caption] Click here to download the file- Watch the step by step video tutorial:
In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two type of search –Search in specific column and Search in all columns. Note: This trick is useful only for small data set. Search in specific Column: To search in specific column, just select the column name form the drop down
In this article, you will learn how to create a Table of Contents for any active workbook using VBA. We have created VBA code which you can put in your personal macro. Below is the code to create the Table of Contents - Option Explicit Sub Create_TableOfContents() 'Check is workbook is protected If ActiveWorkbook.ProtectStructure = True Or ActiveWorkbook.ProtectWindows = True Then MsgBox "Workbook is protected. Please unprotect it first", vbCritical
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
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
In this article, you will learn how to create a User Defined Function in VBA to get the frequency of specific word in a paragraph. Using this UDF you will be able to get the Total Words, Specific word count (Case Sensitive Check) and Specific word count (Non-Case Sensitive Check). For example, we have below given paragraph, and we have got the Total word count and Specific word count also-
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
In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps- Select the excel range. Press Alt+O+E to open the Format Cells window. Go to Number tab. Got to Custom. Put the below code in Type box- “ ■ General; ■ General; ■ General; ■ General” You can take any other
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
