Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
A series line in Excel helps us to connect the data objects of same time period. A series line helps us to analyse the charts more efficiently without any confusion. A series line connects the data objects of same rows with a line. Generally, series lines are added to the stacked or 100 stacked columns. In this tutorial, we will demonstrate how you can add series lines in a chart in Excel. Adding Series Line in an Excel Chart Let us suppose we have an Excel sheet with the following data: Step 1 To create the chart, select the ... Read More
If you have a huge Excel sheet with lots of data and there is a requirement to add a semicolon to each cell, then you wouldn't surely do it manually. In this tutorial, we will show you a simple hack that you can use for this purpose. Adding Semicolon to Each Cell Using "&" Operator Let's start with the first method. You can add a semicolon to each cell using the "&" operator. Step 1 Let us consider we have the following Excel sheet that contains a list of numbers and names. We will be using the concept of adding ... Read More
A pivot cart can help us understand the data in a very efficient manner. In this tutorial, we will show how you can add a secondary axis to a pivot chart in Excel to help depict and comprehend complex data in a simple way. Adding Secondary Axis to a Pivot Chart in Excel Let us assume we have an Excel sheet which contains data similar to the one shown below: Step 1 We need to create a table for the data. To create the table, select the data → click Insert → click table. It will convert our data ... Read More
In this tutorial, we will learn how to catch syntax errors in JavaScript. In JavaScript, we get will errors if we write any mistakes in code. Like, ReferenceError, i.e., when we call a variable that does not exist in our code. TypeError i.e. when we tried to change the value which is immutable or try to use a variable in an appropriate way. SyntaxError i.e. when we tried to interpret invalid code. We will learn more about this error in detail below. What is Syntax Error? A syntax error is thrown when there is a glitch in ... Read More
In this tutorial, we will learn to find the non-digit character with JavaScript regular expression. ASCII code 'A' is 65 and 'a' is 97 etc. Now, we will check how to find a nondigit element (\D) in a given text using RegExp. RegExp is an object that specifies the pattern used to do search and replace operations on string or for input validation. RegExp was introduced in ES1 and it is fully supported by all browsers. Syntax Syntax for the non-digit element is, new RegExp("\D") or simply /\D/ /\D/, is introduced in ES1. It is fully supported by ... Read More
In our code, usually, we will get an issue with errors. Errors will disturb the normal flow of our application. So, it is required to handle error exceptions in our code to implement any application in any programming language. Now, we will see how to handle exceptions in Clojurescript. Before that, first we learn what Clojurescript is. What is ClojureScript? At the fundamental level, Closurescript is an accent of the closure programming language that is used to compile to JavaScript. Actually, closure originally compiled only to Java virtual machine bytecode, later in 2011 Closurescript came as an option to ... Read More
In this tutorial, we learn how to find non-word characters in a string using JavaScript Regular Expression. Actually, word characters include A-Z, a-z, 0-9 and _. Coming to the non-word characters except word characters like !, @, #, $, %, ^, &, *, (, ), {, } etc. Non-word characters, we denote as \W. We all know about RegExp (Regular Expression) in JavaScript. RegExp is an object that specifies the pattern used to do a search and replace operations on a string or for input validation. RegExp was introduced in ES1 and it is fully supported by all browsers. ASCII ... Read More
To calculate text width, we can use the measureText() method in JavaScript. In canvas, the measureText() method is used to measure width of the text content. This means we can pass text to this canvas method and then call that method to measure the text. It will return an object that contains information about the measured text. Sometimes, width may be a float value; hence the Math.ceil() method is used to round the value and returns an integer. Syntax Following is the syntax of the method used to calculate the text width - const text = "Hello World!"; ... Read More
We all know that string is one of the primitive data types in JavaScript. JavaScript allows us to do some operations on strings like finding characters in the string, changing all characters into lowercase or into uppercase, concatenating with other strings, replacing with other strings, searching character(s) or word(s) from string, etc. We denote string in single quotations or in double quotations. typeof string variable will be a string. Syntax Syntax for String() method is, like String(value) value is required. value is JavaScript value. String() method returns a value i.e. as a string. String() method introduced ... Read More
There is a certification program for business analysts known as Certified Business Analysis Professional (CBAP). This program is suited to individuals with substantial business knowledge and years of actual work experience. CBAP is becoming one of the most prestigious qualifications for business professionals. Indeed, since its inception in 2006, the certification program has earned widespread acclaim. Over 1000 professionals now hold CBAP certification in over 30 countries. This number proclaims two facts− the rapidly increasing demand for CBAP among professionals and the certification's global acceptance. Business analysis has grown in popularity since its debut. There has been a significant ... Read More