Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MS Excel Articles
Page 85 of 119
How to change/edit Pivot Chart's data source/axis/legends in Excel?
Excel's Pivot Chart does not allow users to modify the data source it uses. Having said that, you may come across situations where you will need to alter the data source of a pivot chart. This tutorial will show you how to alter the data source of a pivot chart in Excel, as well as how to edit the axis labels and legends of a pivot chart in Excel. Changing a Pivot Chart’s Axis/Legends in Excel Within Excel's Filed List, altering or editing the Pivot Chart's axis and legends is actually fairly straightforward and simple to do. You also have ...
Read MoreHow to change X axis in an Excel chart?
Excel is a program that everyone should be familiar with, whether they are students, company owners, or just those who enjoy looking at charts and graphs. How to modify the X-Axis, which is commonly referred to as the horizontal axis, is consistently one of the most popular concerns concerning Excel. When you are aware of what to anticipate, working with charts in Excel is not that difficult. There is also a Y-axis in addition to the X-axis. The former is laid out in a horizontal fashion, whereas the later is organised vertically. When the horizontal X-axis is altered, the categories that ...
Read MoreHow to change values in a cell range in Excel?
This tutorial will walk you through the steps of using Excel's Paste Special tool to make rapid changes to the numbers in a data range in Excel 2013 and 2016. You will learn the Excel instructions on how to do operations such as adding, subtracting, multiplying, and dividing on a selected range of values. Changing the Values in a Cell Range in Excel Assuming you have a list of data that contains numeric values in the range B, and you want to update all of the numbers in the selected range of cells, for example, by adding the number 10, ...
Read MoreHow to change the shape of comment box in Excel?
Excel cells always have comments added to them so that we can attach useful supplementary data. The shape of the comment box is predefined as a square, however you can change its shape, which we are going to explain in this tutorial. Changing the Shape of a Comment Box in Excel Because of the complexity of this approach, you will need to put in a little bit more effort when using it. Let’s understand step by step with an example. Step 1 The very first thing that has to be done is to put the Change Shape command on the ...
Read MoreHow to change the case to UPPER/lower/Proper in an Excel Sheet?
Consider that you have received a data in Microsoft Excel sheet with all the strings in uppercase. Now for you to read it easily you can change all uppercase strings to lowercase in a Microsoft excel sheet. The methods given in this tutorial can be used to change the uppercase string to lowercase strings. Changing the Uppercase Text to Lowercase Text in Excel Open a Microsoft Excel sheet, and enter the string as per your wish in the uppercase in a blank cell. Now enter the below given formula in the cell beside the uppercase string to get the string ...
Read MoreHow to Convert Decimal Degrees to Degrees Minutes Seconds in Excel
Minutes and seconds are more basic units for measuring rotation than degrees. Using minutes when measuring rotation helps us analyse the values more accurately and efficiently. We can convert decimal degrees into degrees, minutes, and seconds using the VBA application, as it can’t be completed directly in Excel. This tutorial will help you understand how we can convert decimal degrees to degrees, minutes, and seconds in Excel. Here we will demonstrate two methods for converting decimal degrees to degrees, minutes, and seconds and degrees, minutes, and seconds to decimal degrees. Convert Decimal Degrees to Degrees Minutes Seconds Here, we will ...
Read MoreHow to Convert Decimal Number to Binary/Octal/Hex Number or Vice Versa in Excel?
You might occasionally have needed to convert a decimal number in Excel into another format, such as binary, octal, or hexadecimal. In general, decimal numbers have a base of 10 from 0 to 9, binary numbers have a base of 2 from 0 to 1, octal numbers have a base of 8 from 0 to 7, and hexadecimal numbers have a base of 16 from 0 to 9 and A to F. You may learn how to convert decimal numbers in Excel to binary, octal, and hexadecimal by reading this article. Convert Decimal Number to Binary Number in Excel Here, ...
Read MoreHow to change or find and replace first number in cell in Excel?
You can search for something in your worksheet using the Find and Replace tools in Excel. Perhaps you're looking for a certain number or a text string to replace. You have the option of locating the object that was searched for as a point of reference or substituting it with something else. In the search terms that you provide, you have the option of include numbers or wildcard characters like question marks, tildes, and asterisks. You are able to search by rows and columns, search within comments or values, search within worksheets or complete workbooks, and search within comments ...
Read MoreHow to change or convert text to number in Excel?
Sometimes the values in your Excel worksheets appear to be numbers, but they do not add up, do not multiply, and cause mistakes in the formulae that you are using. This occurs frequently because numbers are formatted as text in the document. In many situations, Microsoft Excel is intelligent enough to automatically translate numerical sequences that have been imported from other programs into actual numbers. However, occasionally the numbers are left formatted as text, which might cause a variety of problems in your spreadsheets. While the numbers are kept as text, you won't be able to do jobs in ...
Read MoreHow to change negative numbers to positive in Excel?
The majority of employees who work with Excel spreadsheets are responsible for dealing with numbers included in either large or small datasets. When you work with numbers, you will encounter all varieties of them, including positive and negative numbers, decimals, date and time, and so on. The process of converting these numbers from one format to another is one of the more typical tasks that a lot of us need to accomplish on a regular basis. When performing some computations, you may find that you need to convert negative numbers to positive numbers or to zero, that is removing the ...
Read More