Articles on MS Excel
Name of the Function CONCATENATE Type of Function Text Purpose Join two or more strings into one Syntax CONCATENATE(text1, [text2], …) Argument 1 (required) The first item to join. The item can be a text value, number, or cell reference Argument 2 (optional) Additional text items to join Return Value Text joined together The CONCATENATE…
I hope you will be familiar with this visual effect from the classic SCI-FI movie Matrix. This effect is known in different names like Matrix code rain, Matrix Digital rain, etc. What you see here is an animation created in an Excel Sheet using Conditional formatting, RANDBETWEEN function, and a simple macro. The idea was…
In this article, we will see how to create different types of Actual vs Target Charts in Excel Type 1 (Stacked Columns) To create an Actual vs Target chart from the data given below Select the data Go to Insert Tab > Click on the Icon for insert Column or Bar chart Select Stacked Column…
Gauge Chart aka Speedometer Chart is one of the favorite chart of many Excel Dashboard Experts. But still, Excel doesn’t have a predefined template for Gauge chart. What you see here is a combination of a Doughnut chart and a Pie chart This article is about creating a Gauge Chart by combining a Doughnut Chart…
This article is about creating a Multicategory chart in Excel. For creating a multicategory chart in Excel the data should be arranged in either of two formats shown below. For Creating a Multicategory Column chart, Select the whole data (A1:C13) Click on Insert Tab Click on the Icon for Column/Bar chart present in the Group…
In this article we will see how to create a simple a Column Chart and a Bar chart Column Chart In the data range from A1 to B11 of a worksheet, I have the price details of 10 food items. For creating a column chart from the data given below. Select the source data for…
