Have you ever attempted to include an average line or grand total line in an Excel pivot chart? It appears difficult to show or add an average/grand total line like you would in a typical chart. Create Pivot table Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for creating pivot table as shown in the below screenshot. Step 2 Now, select the data range from A1:B15. Click on the Insert tab on the toolbar ribbon and then select pivot table option to insert pivot table for the selected ... Read More

If your worksheet has a column chart or a line chart, you may find that you need to add arrows to the column chart in order to show how the values are related to one another in terms of increasing or decreasing. In point of fact, there is not a direct method for adding the arrows to the column bar; nevertheless, you can draw the arrow shapes and copy them to the column chart. In this article, I'll discuss the process of adding arrows to a line or column chart. Add arrows to column chart in excel Step 1 In ... Read More

In the Excel workbook by default author will be the name of the person who creates the Excel workbook and it usually is the one name. At times workbook may be created by multiple/several persons, in that case, it requires adding the author names to the Excel workbook. Here you will see how to add and change the author names in an Excel workbook. How to quickly add authors for Excel workbook Below steps guides you, on how to add the other authors to the current Excel workbook. Step 1 Open an Excel workbook, click on File and then select ... Read More

Excel makes it simple to combine two data series into a single chart. Now, only one data point must be added to an existing Excel line chart. Add a single data point in an excel line chart Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for chart in an excel sheet in columnar format as shown in the below screenshot. Step 2 Then, select the cells in the A2:B8 range. Click on Insert tool bar and select chart>Line>2-D Line to display the Line graph. Below is the screenshot ... Read More

You can use the scrollbar feature to show a chart with lots of data, just by dragging the scrollbar, you will see the data changing continuously while it's being displayed in the chart. If a lot of data needs to be shown, you can add the scrollbar. However, there is a tricky part in Excel when it comes to adding a scrollbar to a chart, so follow these steps step by step to finish this task. Add a Scrollbar in Excel You have the following data range wherein you want to add the scrollbar chart to the Excel worksheet. ... Read More

The Y axis is automatically added to the left-hand side of an Excel chart while it is being created. You may need to switch it to your right hand in some circumstances, but how would you go about doing that? You will learn about the workarounds in this article. Add a right hand/side y axis to an excel chart Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for chart in an excel sheet in columnar format as shown in the below screenshot. Step 2 Then, select the cells ... Read More

The purpose of this article is to show you how you can use a formula in Excel in order to add a specified character before each word in a cell. Add a Character before each word in a cell with the Formula The following instructions will help you to add one or a few characters before each word that appears in an Excel cell. Step 1 Open an Excel workbook, select a cell blank cell and enter the below formula mentioned formula into the formula bar and then press Enter key. =”Character”&SUBSTITUTE(cell reference, ’’ “, “character”) Consider you ... Read More

Consider that you have a list of names in which one name is repeated multiple times. Now you need to scan the column for the name which is repeated multiple times and add 1 if another repeated name is entered in the specific cells to show the total number of the repeated name. Below shows an example of how to do this. Add 1 to a specified cell if the cell contains certain text with an array formula The array formula below can help you add 1 to a specified cell if a cell range contains certain text in the ... Read More

When we need to make changes to anything in any cell, editing is a typical practice. Therefore, it is really necessary to get some practice using the shortcut key for this particular activity. There are times when we have to change the content of the cell. Because we frequently need to amend the formula or debug the formula, the shortcut is quite useful. Often, we may need to edit the formula. In addition, it is essential to practice shortcut keys in order to reduce the amount of time required for particular tasks when you are a new learner. Because of ... Read More

When you enable change tracking for a workbook, you will have the ability to choose which changes to accept and which to reject. You can make this decision by selecting the Accept/Reject Changes option from the drop-down menu of the Track Changes command button on the Review tab of the Ribbon. Excel will analyze all of the highlighted changes that have been made to the shared file by you and anybody else who has worked on it, and it will give you the option to either accept or reject specific modifications. Excel will show you a warning dialogue box before ... Read More