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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to add all borders to cells with shortcuts in Excel
We all know Excel will not deliver borders by default. Sometimes you have to add borders to the cells to make them outstanding. Read through this tutorial we will show you how to add the borders to cells in the Excel workbook. Borders in Excel Borders are the boxes that come in lines in the Excel workbook. We can frame the data and provide them with a properly defined limit by keeping the borders. Adding Borders to Cells It’s very easy and useful to separate particular data or highlight the few values in the excel sheet. You can add ...
Read MoreHow to add and remove error bars in Excel?
Error Bar is a versatile tool for displaying data variability and highlighting the gap between the reported value and the true value. Add Error Bar in Excel Let’s take an example to understand how error bars are added and removed in Excel. Step 1 At first, we must create a sample data for chart an excel sheet in columnar format, as shown in the following screenshot. Step 2 Then, select the cells in the A1:B10 range. Click on Insert tool bar and select bar chart>2-D column to display the graph for the above sample data. ...
Read MoreHow to add and use camera tool in Excel
Excel's camera tool is one of its lesser known features. With the help of this tool, you can take a picture of the data set (range, table, chart, etc.). After that, any modifications made to the source data set are reflected in the image that was captured by the camera. It can be used throughout the many sheets in your workbook. The dimensions of the pasted snapshot can be altered, and it can also be formatted, by using the tools that come with the camera. They can also be copied and pasted into documents generated in Word and PowerPoint respectively. ...
Read MoreHow to add axis label to chart in Excel?
When you insert a chart in Excel, it has a title that describes what the chart is about. However, this isn't always enough to convey to the user what the chart is all about. This is where axis labels come in. We always generate charts in Excel to visualise and make the data more understandable. Additionally, adding axis labels to the graphic may help others grasp our data much better. Add Axis Label to Chart in Excel Let’s understand step by step with an example. Step 1 At first, we must create a sample data for chart in an Excel ...
Read MoreHow to add a calculated field to a pivot table in Excel?
You can build calculated fields in a pivot table by using your own personal formulas that are compatible with the total of other pivot fields. Calculated fields can accomplish only so much due to their design, but the pivot tables in your Excel spreadsheet gain access to a potent new tool as a result. Step 1 At first, we must create a sample data for creating the pivot table. Step 2 Now, select the data range from A1:J19. Click on the Insert tab on the tool bar ribbon and then select pivot table option to insert pivot table ...
Read MoreHow to add comma at the end of cell/text in Excel?
When you are working on an Excel Worksheet, you will run into situations in which the last name and the first name are not separated by a comma. Adding a comma between the two names manually can be a difficult and time-consuming task. It is highly typical for there to be an absence of commas in the data. This is particularly true in situations in which the data is copied from word editors. but, when you deal with a vast amount of data, you have to discover a better approach to do it or come up with a different way ...
Read MoreHow to add comma before number in Excel?
Adding commas manually in specific places within cells may be a decent idea when you deal with numerous cells inside your spreadsheet data, but when you deal with a vast amount of data, you have to discover a better approach to do it or come up with a different way to do it manually. When you merely want to display the currency symbols together with the totals for the columns or rows, use the Comma in a huge table of financial data. This format is called the "Comma Style." You can format the remaining data with the Comma Style, ...
Read MoreHow to add comment to a data point in an Excel chart?
You have decided that you would like to make a comment on a particular data point in the chart. if you have a chart that you made in Excel and you would now like to include a personalised comment in the chart, your data-filled cells may be rapidly converted into a visual representation using the quick-format chart and graph functions that are available in Microsoft Excel. If you have a chart that you made in Excel and you would now like to include a personalised comment in the chart, you can use Microsoft Excel to do so. Add comment to ...
Read MoreHow to add dotted forecast line in an Excel line chart?
A chart has data from the past (actual data) and the future (predicted future data), with the historical data represented by a line that is continuous and the future data represented by lines that are dashed. Considering that you have a line chart which displays the actual data, you an also add the forecast data as another data series. Then, the question is how to add a dotted line to the line chart that already exists to show the new predictions. Dotted Forecast Line Let's imagine you designed a line chart to demonstrate the average temperature of the city ...
Read MoreHow to add drop lines in an Excel line chart?
You can use Excel features to insert specified lines or bars into chart displays. You can understand the presented data better, if you add lines to a chart. These lines may include series lines, drop lines, high-low lines, and up-down bars. You have the option of removing the lines or bars from the graph if you decide that you no longer wish to see them. Add Drop Lines These lines extend from data points to the horizontal (category) axis, and they are available in both 2-D and 3-D area and line charts. They assist explain the transition from one ...
Read More