A cluster Column chart is one of the most commonly used chart types in Excel. In this, the column bars related to different series are located near one other. In this article, we learn about how to graph clustered column graphs. A clustered column chart has a different bar but they are connected. They do not show the ratio in a chart because they are not stacked. There are different bars for different categories. Clustered Column Chart with Three Sets of Data in ExcelStep 1: Write the three sets of data in an Excel sheet. i.e. from A1:D14.  elStep 2: Select the data A1:D14 and go to insert. Step 3: Under the chart section, Select the column. Step 4: From the drop-down list select cluster chart.  Step 5: Three sets of cluster chart appears. In this chart, X-axis shows the Monthly delivery of Product 1, product 2, and Product 3 in different places i.e. Udaipur (In blue), Jaipur (In red), and CHD (In green). and the y-axis shows the no of delivery. Editing Your ChartYou can edit your chart if you are not ok with the default chart type. Editing a chart can make the data analysis easy and quick. It also customizes your data. You can change the color of the columns to make them more attr

An Average is a number expressing the central or typical value in a set of data, in particular the mode, median, or (most commonly) the mean, which is calculated by dividing the sum of the values in the set by their number. The basic formula for the average of n numbers x1,x2,……xn is A = (x1 + x2 ........xn)/ n Excel AVERAGE FunctionIn Excel, there is an average function for this purpose, but it can be calculated manually using SUM and COUNT functions like this = SUM(D1:D5)/COUNT(D1:D5) Where, SUM: This function is used to find the sum of values in the required range of cells. COUNT: This function is used to get the count of the required range of cells containing numeric values. Excel provides a direct function named AVERAGE to calculate the average (or mean) of the numbers in the range specified in the function's argument. In this function, a maximum of 255 arguments can be given (numbers/cell references/ ranges/ arrays or constants). Syntax:= AVERAGE(Num1, [Num2], ...) Where Num1 [Required]: Provide range, cell references, or the first number for calculating the average. Num2, ... [Optional]: Provide additional numbers or a range of cell references for calculating the average. Ex

Excel is a wonderful tool and helps you to perform difficult tasks easily by using the defined functions. One such function in MS Excel is INDEX and MATCH. INDEX and MATCH are two functions, but they are used combinedly to find a value using multiple criteria. In other words, you can look up and return values even if there are no unique values to look for. The INDEX/MATCH formula can help you find data points quickly without involving any manual search for them and risk making mistakes. Here, we will understand the syntax and formula in full detail so that you can easily adjust the formula for your particular needs and find values using multiple criteria. There are two ways to use INDEX and MATCH with multiple criteria to find results. INDEX and MATCH with Multiple Criteria using an Array Consider the example (as shown below). Which contains information about the Employee's Name, Designation, Team, and Date of Joining. And we need to find the Date of the Joining of Anuj Goyal who is a Marketing Associate in the company. Collect the prerequisites in the different cells (As shown below). To find a value with multiple criteria in separate columns, use the generic formula below: {

In this article, we will see how we can combine multiple values, and use them as lookup criteria for searching specific value(s) in the excel dataset. For this purpose, we will use the VLOOKUP formula, the most basic formula to perform a lookup for value(s) on excel. We will see a modified form of VLOOKUP to perform a lookup using multiple values. First, let us see a general formula: Formula: =VLOOKUP(v1&v2,dataset_part,column,0) Here, Here v1 and v2 signify those two cells, which will be used for lookup in combination.The Dataset_part signify the starting cell value and the ending cell value, upon which lookup is to be performed. This can consist of the whole dataset as well.The column signifies from which column the value has to be picked up.Here 0 signifies the approximation of lookup in vlookup. It can be set to 1 to enable approximation. Now, let us see in brief, or a summary, how VLOOKUP will work in the Multiple Criteria Column. Here, we have 2 ways of modifying VLOOKUP to make it capable of doing a lookup on multiple criteria, they are: Helper Column.CHOOSE function. Helper column will be a sort of redundant work, as we have to provide merged values of those columns on

This article includes a list of Top companies that offer PSU Jobs without GATE 2025 - Public Sector Undertakings (PSUs) are government-owned companies that offer well-paid job opportunities in the field of Computer Science and Engineering. Many PSUs recruit through the Graduate Aptitude Test in Engineering (GATE Exam) but several PSUs also conduct their recruitment without a GATE Score which means a student is eligible if he/she does not have a GATE 2025 score.Explore the complete list of PSUs Recruitment without GATE including Organization wise notification date, website links, eligibility criteria, salary, benefits, and the last date to apply.PSU Recruitment Without GATEHow to Get a PSU Job Without GATE Score in 2025?While GATE is a common recruitment channel for engineering graduates, many PSUs recruit candidates without requiring a GATE score through alternative selection methods such as written exams, UGC NET, CSIR NET, direct interviews, and skill tests. Below is a step-by-step guide to securing a PSU job without GATE in 2025:1. Identify the PSUs Recruiting Without GATESeveral PSUs conduct their own recruitment processes or consider alternative exams like UGC NET and CSIR NET

Knowing how to sum a column in Excel is essential for managing budgets, financial reports, and large datasets. Whether you’re calculating sales totals, adding expenses, or analyzing business data, Excel provides multiple ways to add up a column efficiently. Many users wonder "how to add columns in Excel" or "how do you total a column in Excel", but few realize there are faster and smarter ways to perform these calculations.In this guide, we’ll explore three simple and efficient methods to sum a column in Excel—using AutoSum, the SUM function, and Excel Tables. By the end, you'll have the best techniques to handle calculations easily, whether you’re a beginner or an advanced user.Sum a Column in ExcelTable of ContentTop 3 Easiest Ways to Sum a Column in MS Excel How to Sum a Column in Excel with One ClickHow to Sum a Column in Excel Using AutoSum How to Use the SUM Function to Total a Column in ExcelSum a Column in MS Excel: Easy WaysHere are the 3 different methods showing how to sum a column in Excel. You can do this with the help of the Excel SUM and AutoSum options, you can use Subtotal or turn your range of cells into an Excel Table which will open new ways of processing your d

A line that bounds a particular chart and shows the behavior as it propagates is known as a trend line. It is generally used for analytics purposes to get a close approximate idea from the chart. The chart can be of any type like Bar Chart, Scattered Chart, Line Chart, etc. By default, we can't directly plot a Trendline over a Stacked Column Chart. Excel doesn't provide us the flexibility to add Trendlines directly to a stacked column chart. In this article we are going to discuss three different methods to add Trendlines on a stacked column chart using a suitable example shown below : Example: Consider the table shown below. It consists of the details of the number of students enrolled in our various courses from the year 2017 to 2020. Implementation : Follow the below steps to implement a Stacked Column Chart with Stacked Trendlines in Excel: Insert the data in the cells.Now select the data set and go to Insert and then select "Chart Sets". In the drop-down select Stacked Column.Stacked Column Now, to add Trendline(s) in a chart click on the "+" button in the top right corner of the chart. But wait, you can observe that there is no Trendline option. Since there is no Trendline o

In this article, we will see how to find the longest or shortest text string in a column in Excel? Usually, for finding the longest or shortest string we can visit the all string in columns one by one and compare them to get results. This seems to work when you have less amount of data in an excel sheet. This is not a particle with a large dataset in Excel. Let's see how you can find the longest or shortest string in the column by using just one single line of formula in Excel. Longest Text String in a Column: We will use the below formula to get the longest text string in a column in an excel file. Syntax: =INDEX(range,MATCH(MAX(LEN(range)),LEN(range),0) Parameters: INDEX: Returns the value of the given position in the columnMATCH: Locate the position of a lookup value in a columnMAX: Returns the largest valueLEN: Returns the length of the given stringrange: Input range of columnExplanation of Formula: Let's start with the inner parenthesis value. LEN(range) will return the array of the length of the cell that comes under the input range. Now MAX will return the maximum numeric value it that is the maximum length from the given array. Now this two are passed to MATCH. It will retu

Suppose anytime you work with colossal tables of data and you want to implant a VLOOKUP function that dynamically updates to the accompanying portion as you copy it across. In that case, the VLOOKUP with the COLUMNS capacity is what you truly care about. That is; the col_index_num a piece of the VLOOKUP capacity intensely revives as you copy it across your worksheet. Before learning VLOOKUP with Dynamic Column Reference, let's first learn what is VLOOKUP function, VLOOKUP VLOOKUP is utilized when one necessities to track down the worth of a cell/data of that cell that is available elsewhere (can likewise be available in another sheet). The following is the capability of VLOOKUP, =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) Example: Okay, we ought to imagine this summary is hundreds or even a considerable number of sections long and we really want to find a quick strategy for getting expenses and maker information on demand (other than CTRL+F for Find clearly). In the table underneath we have the Book Title, Author, and Price. The book title is found utilizing a Data Validation List or Drop Down List, and in sections C and D we want a VLOOKUP equation that finds t

AutoFit is a feature in Excel that helps you to quickly adjust the row height or column width so that your data/text fits completely into the cell. Also, In AutoFit you don't have to manually specify the row height and column width. It will Automatically figure out how much expansion is needed. to fit the text in the cell.  How to AutoFit in Excel Excel Autofit BasicsAs you know, Excel has a certain row and column width by default. But in some cases, we might need to write something that can occupy more space, at that time we have to adjust the row or column width so that our text will not spill out from the cell and remain within the cell.  We can do so with the help of the AUTOFIT feature in Excel. Example of text Spill out from the cell:We can set column width and row height manually as per our requirement by clicking on column width or row height in the Format option in the cells group on the Home tab. When adjusting the size of cells in Excel, whether it's done automatically or manually, it's important to keep in mind certain limits regarding the maximum dimensions of columns and rows. For columns, the maximum width allowed is 255 units. This means that a column can hold up to