You are reading the article Step Chart In Excel – A Step By Step Tutorial updated in December 2023 on the website Kientrucdochoi.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested January 2024 Step Chart In Excel – A Step By Step Tutorial
Watch Video – Creating a Step Chart in Excel
A step chart can be useful when you want to show the changes that occur at irregular intervals. For example, the price rise in milk products, petrol, tax rate, interest rates, etc.
Let’s take the example of a Petrol hike in India. It can happen any day (as decided by the government) and the value remains constant between these changes. In such a case, a step chart is the right way to visualize such data points.
Unfortunately, Excel does not have an inbuilt feature to create a step chart, however, it can easily be created by rearranging the data set.
Step Chart in ExcelIn this tutorial, you’ll learn:
The difference between a Step Chart and a Line Chart.
Creating a Step Chart using the “Line Chart technique”.
A line chart would connect the data points in such a way that you see a trend. The focus in such charts is the trend and not the exact time of change.
On the contrary, a step chart shows the exact time of change in the data along with the trend. You can easily spot the time period where there was no change and can compare the magnitude of change in each instance.
Here is an example of both the line chart and step chart – created using the same data set (petrol prices in India).
Both of these charts look similar, but the line chart is a bit misleading.
It gives you the impression that the petrol prices have gone up consistently during May 2023 and June 2023 (see image below).
But if you look at the step chart, you’ll notice that the price increase took place only on two occasions.
Similarly, a line chart shows a slight decline from September to November, while the step chart would tell you that this was the period of inactivity (see image below).
Hope I have established some benefits of using a Step Chart over a Line Chart. Now let’s go ahead a look at how to create a step chart in Excel.
First things first. The credit for this technique goes to Jon Peltier of chúng tôi He is a charting wiz and you will find tons of awesome stuff on his website (including this technique). Do pay him a visit and say Hello.
Here are the steps to create a step chart in Excel:
Have the data in place. Here I have the data of petrol prices in India in 2023.
Have a copy of the data arranged as shown below.
The easiest way is to construct the additional data set right next to the original data set. Start from the second row of the data. In cell D3, enter the reference of the date in the same row (A3) in the original data set. In cell E3, enter the reference of the value in the row above (B2) in the original dataset. Drag the cells down to the last cell of the original data.
Copy the original data (A2:B18 in the above example), and paste it right below the additional dataset that we created.
You will have something as shown below (the data in yellow is the original data and green is the one that we created). Note that there is a blank row between the header and the data (as we started from the second row). If you are too finicky about how data looks, you can delete those cells.
You don’t need to sort the data. Excel takes care of it.
That’s it! You’ll have the step chart ready.
How does this work:
To understand how this works, consider this – You have 2 data points, as shown below:
What happens when you plot these 2 data points on a line chart? You get a line as shown below:
Now to convert this line chart into a step chart, I need to show in the data that the value remained the same from 1 to 2 January, and then suddenly increased on 2 January. So I restructure the data as shown below:
I carry forward the data to the next date when the change in value happens. So for 2nd January, I have two values – 5 and 10. This gives me a step chart where the increase is shown as a vertical line.
The same logic is applied to the restructuring of the data while creating a full-blown step chart in Excel.
While it would be nice to get an inbuilt option to create step charts in Excel, once you get a hang of restructuring the data, it won’t take more than a few seconds to create this.
Related Tutorials:
Other Excel Charting Tutorials You Might Like:
You're reading Step Chart In Excel – A Step By Step Tutorial
Javascript Tutorial For Beginners: Learn Javascript Step By Step
JavaScript Tutorial Summary
This online JavaScript guide is geared to make you a JavaScript pro! It will help you learn JavaScript step by step. You will learn all the JavaScript basics in this guide.
What is JavaScript?JavaScript is an open-source and most popular client-side scripting language supported by all browsers. JavaScript is mainly used for enhancing the interaction of the webpage with users by making it more lively and interactive. It is also used for game development and mobile application development.
Javascript Syllabus First Steps in Javascript Basics for Beginners👉 Lesson 1
What is JavaScript?
— A Complete Introduction with Hello World! Example
👉 Lesson 2
JavaScript Variables
— Declare Variables in JavaScript, Assign a Value with Example
👉 Lesson 3
JavaScript Array Methods
— Create Array with Example in JavaScript
👉 Lesson 4
JavaScript Loops
— For, While and Do While LOOP in JavaScript (with Example)
👉 Lesson 5
Conditional Statements
— IF, Else, Else IF Conditional Statements in JavaScript
👉 Lesson 6
JavaScript String Format
— Methods with EXAMPLES
Javascript Advance Stuff! JavaScript Interview Questions, Tools, Books & Tutorial PDF
👉 Lesson 1
JavaScript Courses
— 90 Best JavaScript Certification Courses
👉 Lesson 2
JavaScript Books
— 14 Best JavaScript Books for Beginners and Experts
👉 Lesson 3
BEST JavaScript IDE
— List of Top 20 BEST JavaScript IDE
👉 Lesson 4
JavaScript Interview Questions
— Top 85 JavaScript Interview Questions and Answers
👉 Lesson 5
JavaScript Tutorial PDF
— Download Javascript Tutorial PDF for Beginners
What will you learn in this JavaScript Tutorial for Beginners? Are there any prerequisites for this JavaScript Tutorial?Nothing! This is an absolute JavaScript beginner guide to learn JavaScript with examples. However, if you have some basic knowledge of HTML and CSS, it will help you learn faster and more efficiently.
Who is this JavaScript Tutorial for?This JavaScript for beginners tutorial is for students who want to learn about Web application development and software development. This tutorial is also helpful for the professionals working in web application development to enhance their knowledge and skills.
Why learn JavaScript Programming Language?JavaScript is the most popular client-side programming language which is widely used for web application development in every industry. There is a huge demand in the IT industry for candidates having knowledge of JavaScript. Therefore, learning JavaScript is beneficial for you to get a good job and also enhance your skills and knowledge as well.
How do JavaScript engines work?JavaScript Engines are complicated. But it works on some simple basics:
Then it converts or compiles the script to the machine language.
After that machine code runs.
What can in-browser JavaScript do?JavaScript’s functionality depends on the environment it’s running in. For example, chúng tôi supports functions which allows JavaScript to read and write arbitrary files, perform network requests, object-oriented, etc. The roles that JavaScript plays in both client-side (front end) and server-side (back end) development of applications can vary wildly.
In-browser JavaScript also allows you to perform webpage manipulation, interaction with the user and with the web server.
Show dynamic content based on the user profile.
Support features like auto-validated form entries and interactive drop-down menus.
Send requests to remote servers, Upload and download files.
JavaScript code can also create movement and sound
Ask questions to the users, Get and set cookies, show messages, switch browser tabs.
Allows the data to be stored in the local storage.
What can’t in-browser JavaScript do?JavaScript’s capabilities in the browser are quite limited for the sake of the user’s safety. It helps to prevent any unauthorized webpage from accessing private information.
Examples of such limitations are:
JavaScript on a webpage may not allow you to copy, execute or read/write arbitrary files on the hard disk. It doesn’t offer any access to Operating system functions.
JavaScript allows you to communicate over the net to the server where the current page came from. Although, it does not allow you to receive data from other sites/domains.
What makes JavaScript unique?Here, are the three most important features which make JavaScript unique
It offers full integration with HTML/CSS.
Simple things are done quickly without any complication or following strict rules.
Supported by all major browsers and JavaScript is enabled by default.
Alternatives to JavaScriptThe syntax of JavaScript not suited for everyone as different project demands different features. However, some modern tools like a Coffee script, Typescript, and Dart allowing developers to code in another language and then auto-convert into the JavaScript code.
Where is JavaScript Today?ECMAScript is a specification governed by ECMA international aimed at standardizing JavaScript. The latest version is ECMA9 also called JavaScript 9. It is supported by all major browsers like Chrome, Firefox, Internet Explorer, etc. Though each browser has an array of unique commands that are not part of the standards.
How To Create A Custom Gradient In Photoshop (Step By Step)
When you’re working with the gradient tool in Photoshop, being able to create a custom gradient opens up way more of the tool’s potential. So today, we’ll dive into how to do just that, along with how to save your custom gradients for later use.
But if you are not interested in creating tons of gradients from scratch, I’ll touch on a few places to find pre-made Photoshop gradients for free online too!
Let’s get started.
How To Create A Custom Gradient In Photoshop Step 1: Create Or Open The Document You Want To Apply The Gradient ToFirst, open or create a document of the size of your preference. You will apply the gradient to this document. In my case, I made a document of 3000 x 2000 pixels.
Then, go to the Foreground/Background swatches at the bottom of the Toolbar. The foreground swatch is the one in the front, and the background is in the back. These will be the colors of your default gradient. You can change those later within the gradient editor if you want, but it’s a good idea to do it beforehand.
Within the color picker, choose a color you like. In my case, that was the blue shade below.
Repeat the process above to change the background swatch color.
Step 2: Enable The Gradient Tool (G)With the desired colors chosen, enable the Gradient Tool (G) in the Toolbar.
Step 3: Customize Your Gradient In The Gradient EditorThe Gradient Editor gives you many customization options. It’s a complete resource to create the gradient that looks exactly as you want.
The first section of the Gradient Editor is the Presets. The presets are grouped in folders.
In the Basics folder, you can find the default gradient based on your foreground and background colors. You can also find a gradient that goes from the foreground color to transparent. There is also a basic gradient there that goes from black to white.
The other folders are divided into groups of colors or themes. For example, you can find folders with green shades and colors based on common cloud colors.
Moving down the Gradient Editor, you can find a gradient bar containing the foreground and background color you previously chose by default.
The arrows and blocks under the gradient bar are color stops, representing each color that composes the gradient.
Using the Smoothness slider, you can control how harsh or smooth the transition between the colors in your gradient is. The lower this parameter is, the more blended the colors will look.
Add as many colors as you want to the gradient until your gradient looks as you like. In my case, I added four colors.
Step 4: Save Your New Custom Gradient As A PresetYour new gradient preset will appear at the bottom of the gradient presets section.
Step 5: Locate Your Custom Gradient After Saving ItAfter saving your gradient, you can access it at any time in the future by doing the following:
Now, scroll down the list of gradient presets to find yours. It will likely be at the bottom of the list if you’ve just saved it.
Step 6: Apply The Gradient You CreatedAfter you have created your gradient, applying it in a document or photo is easy.
You can control the appearance of your gradient by choosing a different style before applying it. To do this, select one of the Gradient types in the Options Bar.
The Linear gradient applies the gradient from one point to another in the area you are using it.
The Radial gradient applies the gradient in the shape of a circle.
The Angle gradient applies a gradient with a focal point that extends itself in an angular direction.
The Reflected gradient creates a gradient that goes from the first color of the gradient to its end color. However, it also places the gradient’s end color on both sides, creating a mirror effect.
Lastly, the Diamond gradient creates a gradient in the shape of a diamond.
Where To Get Additional Custom Gradients For PhotoshopYou won’t always have time to create a stunning gradient. That’s why it’s always a good idea to store extra gradients when needed.
I selected three great sources of free gradients so you can download them to use in your projects.
Brusheezy is a popular website that offers thousands of free downloadable Photoshop resources.
Even though the focus of this website is providing brushes, it also offers other resources, and gradients are among them. You can find a variety of gradients on this website, such as metallic gradients, gold gradients, and gradients sorted by themes, like floral gradients and photo aging gradients.
Ps files is dedicated to sharing Photoshop resources. You can find anything from brushes, flyers, and text effects on this website. All resources there are free to download and are uploaded by its members. You can join the website if you want and share your own resources too!
Gradients on the website have their own section. You can find many high-quality gradients there. Browsing the website, you can find stunning packages with hundreds of preset gradients.
Graphics Fuel is an excellent source of graphics, both free and premium. There you can find lots of design freebies, including PSD files and icons. Beyond that, they also publish design articles, so you can keep up with the latest trends and get more informed about the design world.
A quick search on the website can uncover some valuable gradient sources for free. For example, I found a nice collection of 24 vibrant gradients that can make your next project stand out.
A Step By Step Guide For Data Visualization Using Tableau
This article was published as a part of the Data Science Blogathon
Introduction to Data Visualization using TableauOur goal as Data Analysts is to get the insights from our data in such a way that everybody who sees them can easily understand their implications and how to act on them.
Tableau is a data analytics and visualization tool. It’s the leading (33% market share followed by Power-BI) data analytics and visualization tool in the market. Tableau comes with a very easy drag-drop interface which makes it easy to learn and you can work on almost every type of data in Tableau.
This makes it an excellent choice for data analysts.
Table of ContentsThis article will give you a walkthrough of all essential features of the Tableau, which you must know in order to work on it:
Installing Tableau on your System
Getting Started with Tableau!
Tableau Visualizations – Charts, Tooltips, Maps
Tableau Visualizations – Formatting, Colors
Parameters, and Calculated Fields in Tableau
Analytics in Tableau (Forecasting, Clustering)
Creating Dashboards in Tableau
Crafting your own Story in Tableau
Tableau provides us various services according to our business need Tableau Desktop, Tableau Public, and Tableau Online, all these offer Data Visual Creation. Choice of Tableau depends upon the type of work.
Tableau Desktop is a program that allows you to execute complicated data analysis tasks and generate dynamic, interactive representations to explain the results. Tableau also lets you share your analysis and visualizations with the rest of your company, allowing everyone from coworkers to top management to look into the data that matters to them.
Before you can begin using Tableau, you need to download the Tableau setup from the link and then accept all the licenses and agreements. After installation, you will get a home screen same as the given picture below.
After installation, if you find this Homescreen you are good to go:
Getting Started with Data Visualization using TableauOnce you have installed Tableau in the system, let’s start with some real-world Data Visualization using Tableau.
Load Data in TableauWe will be using global superstore data throughout the article, which is perfect for learning purposes. This link will take you to a page where you may download the dataset. The downloaded file is a zip file that contains an excel that looks like the given picture below:
Now we have an excel file and Tableau installed let’s load the data set into Tableau. Tableau also gives us some flexibility to create new columns, rename, split, edit alias, join tables, some preprocessing before loading the data into Tableau. The below image will demonstrate to you how to load data and perform some preprocessing.
Tableau supports various data formats which can be loaded by choosing those options. Under a file we see various options to load data from the local directory and under to a server, we see options to load data from cloud servers. for loading CSV files we select Text file options, for excel and SQL files we choose their respective options.
Connect Tableau to the data file:
the Drag Sheets Here area, as shown in the above gif.
After loading we can perform data cleaning, data preprocessing, feature extraction to some extent.
Understanding different Sections in TableauUp until now, we have Tableau loaded with global-superstore data and now we can see Tableau work-page. Tableau work-page consist of different section. Let’s understand them first before plotting our graphs.
Source: Local
Menu Bar: Here you’ll find various commands such as File, Data, and Format.
Dimension Shelf: This shelf contains all the categorical columns under it. example: categories, segments, gender, name, etc
Measure Shelf: This shelf contains all numerical columns under it like profit, total sales, discount, etc
Page Shelf: This shelf is used for joining pages and create animations. we will come on it later
Filter Shelf: You can choose which data to include and exclude using the Filters shelf, for example, you might want to analyze the profit for each customer segment, but only for certain shipping containers and delivery times. You may make a view like this by putting fields on the Filters tier.
Marks Card: The visualization can be designed using the Marks card. The markings card can be used to change the data components of the visualization, such as color, size, shape, path, label, and tooltip.
Worksheet: In the workbook, the worksheet is where the real visualization may be seen. The worksheet contains information about the visual’s design and functionality.
Data Source: Using Data Source we can add new data, modify, remove data.
Current Sheet: The current sheets are those sheets which we have created and to those, we can give some names.
New Sheet: If we want to create a new worksheet ( blank canvas ) we can do using this tab.
New Dashboard: This button is used to create a dashboard canvas.
New Storyboard: It is used to create a new story
Creating Visuals in TableauLet’s begin with the real data visualization using Tableau-
Tableau supports the following data types:
Boolean: True and false can be stored in this data type.
behavior when applied to valid date or DateTime fields.
Number: These are values that are numeric. Values can be integers or floating-point numbers (numbers with decimals).
String: This is a sequence of characters encased in single or double quotation marks.
Geolocation: These are values that we need to plot maps.
Follow these steps:
drag the dimension and measure in row and column input field and it will automatically suggest a graph best fitted on data.
you can also remove the axis just by dragging and dropping them under the marks card (remove field).
From the above image, you might have observed that the default aggregation on the measure is sum but you can change the aggregation to sum, avg, min, max, etc, you can also customize the axis name, orientation, size, show-hide axis as shown in the above image.
Enhancing The Analysis:In order to create a beautiful interactive visual, you must understand the following features:
a. Marks card
Marks card is very important for plotting graphs. In marks card we have:
Colour button which is used to give different colors to different categories and measures,
Size button is used to give size which depends on how big a value is. The bigger the value means bigger the size of a particular mark
Tooltips, here you can add information like ( profit, quantity, sales, discount, category, state, etc.) which will be visible on hovering over the graph
The Details button allows you to display more information without affecting the table’s structure. which is used to show details about particular points. dragging a field on details buttons will show the details of that point, and this feature is majorly used for maps to show more details of a particular point.
b. Filter
After creating some plots you might want to use different filters, to do so follow these steps:
On the filter shelf, you can drag any measure or dimension whichever you want to apply a filter on.
As you drop the field a box will appear, now you can select any particular category, or top-n rows according to measure values or you can write some rules to select top rows or by using some parameters.
c. Hierarchy
You can quickly establish hierarchies with Tableau to keep your data organized.
Hierarchy is basically nesting the same type of related data together. Tableau calendar data is an example of a hierarchy.
d. Parameter
A parameter is a workbook variable like a number, date, or string that can be readily managed by the user to replace a constant value in a calculation.
In the above image, our goal was to choose the top N countries having maximum sales but here we wanted to let the user select how many top countries they want to list. To accomplish so, we’ll need to create the following parameters:
Select a data type from the Data Type drop-down menu, in my case, I have chosen to int range from 1–100 list and the current value will be 5.
Here we wanted to choose top-N countries based on the sales. drag country field to filter shelf and choose top tab and then choose variable1 in by field section and choose SUM(SALES).
Now slide the parameter value and observe the difference.
e . Calculated field
Tableau gives us the option to create a calculated field where we can create our own new field( column). Tableau comes with many functions like if-else, switch, case, date diff, level of dimension which is extensively used for our visualization
To segment data
level of details(LOD)
To change a field’s data type, for example, from a string to a date.
To aggregate data
handling date time
To filter results
To calculate ratios
Creating Calculated Field:
Here our goal is to calculate delivery days using order date and ship date:
Give the Rule to calculate delivery days in the rule box. here we will use the DATEDIFF function to subtract two dates.
Type Rule: delivery days = DATEDIFF(‘day’, [shipdate],[order date])
now drag the delivery days field in rows or cols.
since calculated field is the most powerful features of Tableau.
f. Format
Data Analytics in TableauIn the Analytics tab, we have several analytical tools like forecasting, clustering, trend line, Average line, constant line, etc. let’s see in action.
Source: Local
Steps to perform Analytics:
From the Analytics tab on the left side, you can choose various options.
Dragging and dropping a constant line on a particular X, or Y-axis draws a line at a given constant value.
The trend line is not the same as forecasting. The trend line only tells us if the overall trend is increasing or decreasing.
Maps in TableauWe can easily draw maps in Tableau if we have geographical data aka a location field (country, city, state, etc). Tableau has 2 types of maps, symbol map, filled map.
Source: Local
Steps to create Maps:
Drag Country field in the worksheet, it will draw a symbol map.
Dropping city on Details will show the names of cities on the map.
you can also decide the colors of different states based on the sales amount on the filled map.
sort them by giving their specific country, city , state, pin-code etc.
Colors: You can adjust colors of visualization based on categories and on the magnitude of measure values.
Source: Local
From the above image you see that the color of bars has decided by the profit amount, more profit means more bluish in color, more loss means more reddish in color
adjusting colors is so simple in Tableau:
Drag a dimension or measure in the color shelf under the marks card.
Now you see colors are now visible as a legend.
you can choose a wide variety of colors, modes of coloring like stepped or continuous bar and
you can edit the range of colors as well.
Tooltip: When we hover over a particular point on the graph we see a box showing up details about that particular point, this is basically a tooltip. we can add information to show as a tooltip, let’s see an example.
As you can see dragging a field on the Tooltip button adds details in the tooltip which can be seen on hover, we can also customize the text, color, font of the tooltip.
Designing a Dashboard in TableauCombining multiple views with filters, interactivity, legends on the same page is simply our dashboard. it helps us to see all views on the same page with fully interactive features. Let’s see an example.
Steps to create a dashboard in Tableau:
Adjust the layout of the dashboard. you get fixed or automatic sizes based on the screen size to choose from.
On the left-hand side, you can see that our all graphs (viz) are visible so you simply need to drag and drop them into the dashboard.
You can drag as many as sheets you want to include in our dashboard.
dashboard. If you find managing spaces and layout difficult in the dashboard try floating sheets.
You can also apply filters on different visuals present in our dashboard. More information on the dashboard may be found here.
Storytelling in TableauThe story in the Tableau is narrated walkthrough of one or more sheets or dashboards. each view in the story is called a Story Point.
In storytelling, we take a visual and write a narration about the insight that has found from visual
Creating a story is the same as creating a dashboard, just drag our visual on the story page and give narration. You can add as many visuals as you want along with narration.
Source: Local
Actually creating story points in Tableau is easy. You can see an example of creating a Story Point and experience Tableau’s free on-demand training at the same time! Go to Tableau’s training page.
Saving your Tableau Work:Tableau comes with autosave features so you don’t need to worry if you couldn’t save your work manually.
You can save your work in various ways:
Tableau Desktop
Tableau Server
Tableau Public
Tips:
The Undo Button Is Your Friend
Pay Attention to Visual Cues
Save Early and Often
Final Thoughts on TableauThis is all you need to know about Tableau in order to create good-looking charts and dashboards. I tried to cover as much as I could although it’s not the ending. You can learn more about formatting, calculated field, pages, animation, extensions, etc. in order to go in-depth with Tableau you must practice different kinds of data and it will help you analyze and present data efficiently and in a nice manner. I highly encourage you to go through the free learning material given by Tableau.
The media shown in this article are not owned by Analytics Vidhya and are used at the Author’s discretion.
Related
How To Delete Or Recover A Design In Canva (Step By Step)
If you’re a regular Canva user, chances are, you have tons of designs that need to be deleted permanently. The question is, how do you make sure that once you throw your design in the trash, no one else can fish it out and claim it as their own? The process is simple but requires an extra step many people forget to do.
If you’re a Canva Pro user, your account has a 100 GB space limit. If you are a free Canva user, you only have 5 gigs to work with. So deleting old designs permanently is important not just for staying organized, but for making sure you don’t go over your limit. I will show you how to delete your designs on both desktop and mobile. Not only that, but I’ll also show you how you can bring your designs back if you made a mistake.
How To Permanently Delete A Design In CanvaFirst, I’m going to show you the quickest and easiest way to delete your design forever. I will cover this for designs only you can access, and also for shared projects.
Here’s an old design in my Canva projects folder that’s out of season and needs to be deleted permanently.
Step 1: Trash Your Project Step 2: Open Your Trash Step 3: Hit The Red ButtonThe warning is not fooling around either. Once you hit the Delete Permanently button, your project is gone forever.
How To Delete Shared Designs In CanvaIf you use Canva with a team, there will be times you need to delete a project and make sure your team can no longer access it.
Step 1: Find Your Shared Project Step 2: Trash Your ProjectThen, select Move To Trash.
Step 3: Open Your Trash Step 4: Hit The Red Button How To Recover A Deleted Design In CanvaSo you just deleted a design because it’s months out of season. Then it hits you: “I’ll need that design when the season rolls back around!”
Don’t worry. I’ll teach you now how to recover your recently deleted design.
Step 1: Open Your Trash Step 2: Locate And Restore Step 3: Double-CheckTo confirm that your project is restored, go back to the Canva Homepage and check under Recent Designs. You should find your recently deleted project back and ready to edit.
The one thing to remember about your trash is that it will automatically empty after 30 days. So if you have any second thoughts about deleting your designs, you have 30 days to make your decision to restore them.
How To Delete A Design In Canva MobileWhen you need to delete your designs on the go, you’ll be happy to know that you can do so on mobile just as quickly and easily!
Step 1: Locate And Trash Your DesignOn the mobile version of the Canva Homepage, tap on Your Projects.
Tap on the Three Dots in the upper right corner of the project you wish to delete to bring up the options. Select Move To Trash.
Step 2: Find Your Design In The TrashThe project disappears from your recent designs, but your project is not yet permanently deleted. To permanently delete your project, open your Trash from the Canva Homescreen.
Step 3: Delete Your Design PermanentlyFind your project and tap on the Three Dots. Then, select Delete Permanently.
You will receive a warning that you should take seriously. Tap on Delete Permanently, only if you truly want to delete your project forever.
How To Recover A Design In Canva MobileWhat’s great about making mistakes in Canva, is that you can fix them, even on the go!
Here’s how you recover a recently deleted design on your phone.
Step 1: Open Your TrashOn the mobile version of the Canva Home Page, tap on Trash.
Step 2: Restore Your DesignOnce your Trash is open, locate the design you would like to bring back to life. Tap on the Three Dots in the right corner of the project. When the option pops up, select Restore.
Step 3: Double-CheckTrust but verify when it comes to any computer program. After tapping Restore, go back to the Homepage and tap on Your Projects.
Under Recent, make sure that the project you restored is there. If it isn’t, go back to your Trash and restore it again.
100+ million premium stock photos, videos, audio, and graphics
610,000+ premium and free templates with new designs added daily
Up to 100 Brand Kits to establish your brand’s identity online
Remove image backgrounds instantly with Background Remover
Resize designs without quality loss with Magic Resize
Schedule social media content to 8 platforms
1TB of cloud storage
24/7 customer support
Get Your Free Trial
How To Make A Passport Size Photo In Photoshop (Step By Step)
Here you’ll learn how to prepare a passport-size photo in Photoshop and how to create multiple copies of it. Since these image requirements will vary based on your country, it’s important to confirm the exact dimensions requirements before getting into Photoshop. However, once you know which dimensions are needed, it’s easy to make any photo passport sized in Photoshop.
Here’s how!
Size Requirements For Passport PhotosFollowing the mandatory photo size required by your government is crucial since submitting a passport in the wrong size will automatically result in rejection.
You can find the size requirements for a few countries below.
US
In the US, you must submit a 2 x 2-inch passport. Additionally, the size of your head in the photo must measure between 1 inch and 1 3/8 inches.
EU
If you live in a country that is a member of the European Union, your passport size must be 1.38 x 1.77 inches. The image also can’t be larger than 10MB.
Canada
If you live in Canada, you must submit a 2 x 2 3/4 inch passport image. Your head must be between 1 1/4 inches and 1 7/16 inches in size in the photo.
Standard Image Requirements For Passport PhotosSpecific image requirements for passport photos vary from country to country, with some being stricter and others more flexible. However, particular rules apply to the majority of countries.
If you have any doubts, consult your country’s legislation and remember that your photo should make it easy to identify you.
Here are the most common image requirements for passports around the world:
You must use a recent photo – generally no older than six months;
Your image must have a white background;
Your facial expression must be neutral – no smile, no angry face;
Your head must be facing the camera – no side profile, for example;
You can’t use accessories that cover your face or head, such as glasses or caps. Most countries allow you to wear religious hats and head coverings as long as they don’t cover your face;
Your photo must be correctly exposed (no harsh shadows or glare, for example)
How To Create A Passport Size Photo In PhotoshopYou will learn how to prepare your photo as best you can so you can submit your passport photo and get immediate approval. To achieve this, you must ensure the image is exposed correctly and formatted in the correct size. Luckily, this is a straightforward job.
Before anything, you need to scan your photo to identify problems. In my case, for example, there were harsh shadows on the right side of my photo.
After identifying the problems in your photo, you can follow the steps below.
Step 1: Edit Your Photo Using Camera RawFirst, open your photo in Photoshop.
Within Camera RAW, select the Basic tab.
You can adjust the overall brightness of your photo using the Exposure slider.
The Contrast slider allows you to adjust the difference between shadows and highlights in your image.
In Highlights, you can control the brightness of the lightest parts of your image.
In Shadows, you control the brightness level of shadows in your image.
Reducing Whites helps in getting rid of blown-out pixels.
You can adjust the amount of Blacks in your image to reduce the overly dark areas.
You can also benefit from adjusting your image Texture. It helps reveal details that may be lost while adjusting other parameters from the Basic tab.
You can adjust your image Clarity.
If your image has haze, reduce it using the Dehaze slider.
By adjusting Vibrance, you can make the colors in your photo look more lively.
In Saturation, you can reduce or increase the intensity of the colors in your image.
Finally, you can open up the Detail tab and increase Sharpening to highlight the details in your image.
Before After
Step 2: Select Your SubjectTo remove the background, first, enable the Object Selection Tool (W) from the Toolbar.
Step 3: Refine The Edges of Your SubjectWithin the Select And Mask workspace, select the Refine Edge Brush Tool.
Now, zoom in on the edges of the hair by pressing Control + + (Win) or Command + + (Mac) and paint over the edges of the hair to refine it. Press the right bracket key to increase brush size or the left bracket key to decrease it.
You can also use the Brush Tool (B) to refine the edges of your subject.
Then, zoom in on the subject’s edges and paint over them to refine them.
To eliminate the remaining pixels from the image’s original background, scroll down the Properties panel and tick off the Decontaminate Colors option.
When you are done adjusting the Select and Mask settings, set the Output option to New Layer With Layer Mask.
Step 4: Create A New DocumentIn the New Document window, change the unit to inches.
Then set the width and height to the required size for a passport in your country. For this example, I choose the standard values for US passports, 2 x 2 inches.
Set the Resolution to 300 Pixels/Inch.
Step 5: Place Your Image Into The New DocumentNow return to your image tab and enable the Move Tool (V).
Select the image thumbnail in the Layers Panel.
Press Control + T (Win) or Command + T (Mac) to fix this. Control handles will appear around your image.
Push any of the handles down while holding Shift to scale down the image.
Then use the Move Tool (V) to adjust the position of the portrait and put it in the center of the document.
Hit Enter on your keyboard to confirm the action and disable the Free Transform Tool.
Step 6: Add A White BackgroundSelect the layer under your photo.
Then choose Solid Color.
Now enter the code #FFFFFF in the hexadecimal box to set the background color to pure white.
With that done, your passport photo will be ready to use!
How To Make Multiple Versions Of A Passport Photo In PhotoshopIf you want to print a page full of passport-sized photos, to keep on hand for when you need them, you can quickly make multiple versions of the passport photo you created in the previous section. This is useful if you need multiple images for different reasons, such as a passport and a driver’s license, if the image size requirements are the same. To do this, first, select the Rectangle Tool (U).
Then, drag the shape from top to bottom until it covers the photo.
Afterward, go to the Options Bar and set the Fill to transparent.
Set the Stroke to white.
Set the stroke width to 40 px.
Hit Enter on your keyboard to confirm the action.
Then, go to the Layers Panel and make sure the Shape layer is above the image layer.
Name the pattern, anything you want, and press OK.
Set the unit to Pixels.
Set the Width to 1200 and the Height to 800. You can size the document based on how many images you want to fit on the page. To work out the inches, divide the pixel amount by the resolution you set.
Set Resolution to 200 pixels/inch. Since I’ve set the resolution at 200, my document size in inches is 1200/200, which is a width of 6 inches, and 800/200, which is 4 inches. So my document is 6 x 4 inches in size, which means I can fit 6 2×2 inch photos on it.
Select Pattern from the list.
Then select your passport photo.
In Scale, you can control the number of copies of your photo that will fit your new document. The exact value depends on the size of your image. In my case, 67% was enough to fit 6 photos at the correct size.
Learning how to create your passport photos means you don’t need to leave your house or struggle to find a good photographer. This is handy, especially when you are in a rush to get your passport documents in order. It does take some basic knowledge of Photoshop, but nothing too complicated, as you can see here.
Update the detailed information about Step Chart In Excel – A Step By Step Tutorial on the Kientrucdochoi.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!