Web
Analytics

Tips

How to Create a Google Doc in 3 Easy Steps

Published

on

Google provides efficient tools to create and share documents, ultimately resulting in easy going office stuff. Be it a spreadsheet, a document, a form or a slide.
Google docs is primarily a web-based application bridged with Google drive service. Google docs, Google sheets, Google slides and Google forms being the part of the entire suite. It facilitates the user to create, edit and share the documents online while having an alliance with others that too in real time.

Wikipedia defines Google Docs as Google’s “Software as a service” office suite. Google Docs also lets the user to export the document in the desired file format in his/her own local system.

Google Docs is one of its kind of cloud computing document-sharing services. Though it is free for individuals but it takes a charge starting from $5/month from the business enterprises.

See Also: How to Use Google Plus for Business?

Here are some fast facts about this online office suite:

Google Documents: We can put in a maximum of  1,024,000 characters in a Google Document.
Google Spreadsheet: Spreadsheets can have a maximum of 2 million cells.
Google Slides: The utmost size of Google Slides can go up to 50 MB, which is approximately about 200 slides.

 

How-to-Create-a-Google-Doc-in-3-Easy-Steps

How to create a Google Doc?

See Also: How to Create a Google Form?

Well, let’s now get down to the nitty-gritty of it! To make it easier for us we are going to break this article into three major portions with each one detailing out one form of how to make a google doc from the actual docs to spreadsheets and even forms!

#1. How to Make a Google Doc via a Web Browser?

Step #1: Go to this link and click on “Go to Google Docs“. Then sign in with your Google account.

Step #2: After you log in you will be redirected to a web page. Select the type of document you want. you can select from various variants like Resume, Letter, Report, Newsletter and many more.

Now, type in the desired content.
Step #3: Share the doc by clicking on the share button positioned at the extreme right corner.

You can share it via mail or you can also get a shareable link to share it through different channels and whoa,  you are done with it!

Now that you know how to create a google doc, we will begin with the next part of our tutorial!

#2. How to create a spreadsheet and share it in 3 easy steps?

Step #1: Go to this link and click on “Go to Google Sheets”. After that log in with your Google account.

Step #2: Select the type of sheet you want. you can select from various options like to-do list, annual budget, monthly budget and many more.

Enter the data in the selected document page.

Step #3: Share your sheet by clicking the share option positioned at the extreme right place of the web page. Do not forget to give it a title before sharing.

Share your sheet anywhere just by forwarding the link provided. Google also facilitates the user with a facility to share it via mail. Click on done and you are actually done with it.

We are confident that you must know how to use a spreadsheet, and won’t be needing any help with that! With the knowledge of how to do a spreadsheet in our pockets, we move on to the final tutorial in this 3 part series.

Yes, this is about how to make Google Forms! Starting it up is very easy indeed, in fact, we use the same process as we did when we showed you how to how to start a google doc earlier in the article!

#3. How to create a Google form and share it in 3 easy steps?

Step #1: Follow this link, click on “Go to Google Forms” and log in to your Google account.

How-to-Create-a-Google-Doc-in-3-Easy-Steps

Step #2: Click on the “+” sign positioned at the extreme bottom corner of the web page. you will be redirected to a web page where you will be asked to fill in your desired things which you need to put in your form.

Step #3: Click on the send form button in order to share it.

Likewise others you can also share it via mail or a shareable link or you can also share link to various social media channels like Google +, Facebook, Twitter. Click done in order to complete the process.
The responses corresponding to your Google form will be stored in your Google drive space.

So, this brings the end of this tutorial. We started off with one simple question .”How to create a google doc?” and wound up learning about two other wonderful services provided by Google’s Office Suite!

Kindly share if you find this post worthy of it and if you have any query regarding Google Docs and it’s functioning, feel free to share it with us via comments and we will try our level best to solve your query. For more interesting articles on Google Chrome feel free to check out this link!

Keep visiting and thank you for giving it a read.

A student of life, writer, technology freak, and a thinker. Like to invest my time into Digital Marketing and help clients easily reach their marketing goals with proven strategies and roadmaps.

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Tips

How to Speed Up YouTube Videos?

Published

on

How to Speed Up YouTube Videos?

It’s a slow day, you’re at your house, in your pajamas. Then you decide to take some action and do something constructive- that is, browse youtube. As you switch on YouTube and type in the name of the video you’re anticipating to watch, you’re excited.

The video starts up, and you get happy- but happiness, this happiness is short-lived. Why? Well, because the video that you’ve been so excited to watch starts buffering, and then you wish that you knew how to change speed on YouTube.

All of your happiness drains out and the smile is replaced by a frown. But all you need to learn is how to speed up YouTube videos.

We all know this feeling too well, don’t we? Since most of us spend a lot (read: A LOT) of time on YouTube, checking out different videos, and exploring unknown areas.

Hence, it’s quite a pain when the video we have been anticipating about refuses to play smoothly, disallowing you from having a good time.

So to address this global issue, today we shall present certain ways that might be able to reduce this pain.

These methods and hacks will show you how to speed up YouTube videos, which can make your tubing experience far more easy and convenient.

Any consistent YouTube user is likely well aware of one incredibly frustrating word: buffering. Depending on your network, you may spend more time blankly staring at the loading screen than you do enjoy the content.

Now, while you might suspect your ISP of limiting bandwidth while using the popular video-streaming service, even the fastest Internet connections can leave YouTube users out in the cold.

How to Speed Up YouTube Videos:-

This is a common phenomenon and affects millions of people worldwide. Then, why does it happen?

YouTube uses what’s called Dynamic Adaptive Streaming over HTTP — known as DASH for short — to break down the entire video-content sequence into a swath of HTTP-based files that each contain a mere fraction of the full sequence.

As the video plays, DASH selects which sequence to download and play based on network availability and performance. It’s quite a lot of work, whether it’s a three-minute clip or a lengthy two-hour video, irrespective of the length.

Although DASH aims to help speed up downloads and make them more efficient, it also tends to slow down operating performance while using even the fastest of Internet connections.

That said, there is a way to remove this roadblock of a problem, as disabling DASH when using Google Chrome or Firefox, or opting for YouTube’s “Feather” beta or HTML 5 trial, can speed up video playback.

Disable Dash in Google Chrome, as Mentioned Above

Disabling the DASH functionality via YouTube Options, a download-able Google Chrome extension, is one easy way to get rid of the constant buffering and learn how to speed up a video.

The best thing about this particular way is that the installations free, plus you don’t have to go through a number of hassles to install this, as the installation is quite painless.

The catch here is that when you use this extension, you will be letting go of bulk of playback options and opting for a barebones interface while viewing videos.

Following are the steps to use this method correctly

  • Go to the YouTube Centre Download page within the Mozilla add-on store. Click the yellow Add to Firefox button near the top of the page to automatically download the add-on. Afterward, click the Install button at the bottom of the resulting pop-up window to confirm the download.

Then proceed on to the home page of YouTube. Click on the Gear Icon located to the right of the sign-in button to access YouTube Centre’s settings panel.

Next, click the External Players tab within the left-hand navigational pane and uncheck the box directly to the right of DASH Playback to disable DASH when viewing videos on YouTube. The add-on will automatically save and apply the changes when finished.

YouTube’s HTML 5 trial

Not everyone prefers downloading additional browser extensions and additional ones. Some people just don’t want to go into all that trouble.

Thankfully, opting into YouTube’s HTML 5 trial is another viable method for downloading and subsequently viewing YouTube videos sans flash streaming, while placing users on the cutting edge of Internet technology.

Though the HTML 5 player is available on the five most popular Internet browsers — Google Chrome, Mozilla Firefox, Internet Explorer, Safari, and Opera — it’s still in development and does occasionally face some stability and occasional compatibility issues. Once requested, videos will play using HTML 5 whenever possible.

Follow the following steps-

  • Go to You tube’s HTML 5 page
  • Click the blue Request the HTML 5 Player button located near the bottom.

A different alternative-

Besides offering the HTML 5 trial, YouTube also offers another alternative- known as you tube’s Feather Beta. Commonly known as you tube’s Feather” beta, the software aims to serve up YouTube playback with the lowest latency possible.

For this purpose, YouTube limits the number of available features while viewing videos, essentially stripping away typical options and making use of advanced Web techniques for reducing the total amount of download-able data.

The recommended videos section also undergoes some changes- it is then reduced to a mere five suggestions, the share boxes are gone entirely, and other notable components are tucked to the wayside.

It’s similar to the typical YouTube layout, not very different- but with minor changes, and comes with an uptick in video playback speed.

Reduce Video Quality

YouTube has been working hard to make 720p and 1080p streaming available with many of its videos, which is great if your Internet connection can keep up.

However, that requires a lot of bandwidth. Although YouTube will try to choose the right quality for you based on your Internet speed and computer’s specs, it doesn’t always hit the mark.

To avoid the buffering, if your internet speed doesn’t support it, go to the bottom right corner of the video From here, set the video quality to a lower number to reduce video resolution.

The videos won’t look as nice, and you will miss out on the HD quality but in some cases, it may be the only way to get a video to buffer quicker. Also, at least they will play properly.

Final Words

So the above mentioned are all the possible methods to learn how to speed up YouTube videos by applying various strategies. Now, that you have learned this easy technique, you can merrily spend your weekend by watching some funny movies, or even learn some things.

Also Checkout: How to delete Vine account

Continue Reading

iPhone

How to Fix When iPhone Says ‘No SIM’?

Published

on

By

Technology has changed our way of living to such an extent that we depend on so many things to carry out our day to day activities. Right from buying groceries to booking tickets for travel, we do it online. All thanks to the internet and the introduction of Smartphones, things couldn’t have gotten any better.

The iPhone, which is one of the most reputed smartphone models, has offered its owners something really very precious in the form of a phone. There are some amazing features in an iPhone that lets you do so many things.

It is very different from the other smartphones in the market; so, users have difficulty when they come across some error notification on their phones.

There have been people who have asked many questions online like how to fix when iPhone says no sim, why does my iPhone say no sim or why does my iPhone say no service. There’s a solution to all of these questions.

There is a big competition in the smartphone market among the top phone manufacturers to gain more market share. Therefore, innovation has become the prime way to stand out and win people over. There have been multiple productive features added to the phones every single time a new phone is launched.

It is either a bigger screen phone with a better camera or preference is given to music and video players on the phone that enhances the listening and viewing experience for the users. There have also been thousands of productive apps that help users in finishing their work in a much easier way.

Ultimately, customers are being benefited with all the new features these top phone makers introduce. So, competition among the top phone manufacturers can actually be seen as a big blessing for the users and loyal fans of these big brands.

iPhone is one of those brands that have been on top since the time it was introduced. It has made sales worth billions and is in very good standing. There is something unique about Apple that makes it the brand that is most loved by its users and fans across the globe.

From its first edition, iPhones have been designed in a very beautiful manner; the phone looks classy be it an iPhone 3G or the iPhone 6S. Apple invests a huge chunk of money in research and development and without a shadow of a doubt, the outcome is something spectacular each time.

They are rightly called the innovators as they are the ones who introduce something new most of the time in the Smartphone business. iPhones are extremely user-friendly and they come with so many fantastic features.

This phone can be completely customized as per your needs. The camera is just out-rightly superb and listening to music on an iPhone is the best thing you can ever do because of the sound clarity. If you are a music lover, then you must have an iPhone for sure.

There are millions of apps that are available in the app store, which can be downloaded and used. The best part is unlike other smartphones, iPhone hardly hangs even if multiple apps are open at once. This is the beauty of the iPhone.

Apart from selling quality products to its customers, Apple also provides great service. Though iPhones are really user-friendly, there have been times when people have found certain issues with using their phones. There are many online platforms where people look out for solutions for the issues they are facing with iPhone

If we go and check out these forums, we will see some questions like do iPhones have sim cards, or there are people who just put up the issue that they face or the notification they get on screen like iPhone no service or iPhone says no service, iPhone no sim card, no sim card installed.

Some of these questions might sound silly, but honestly, there are many people who are seriously looking out for an answer. Therefore, we will be discussing this issue shortly.

An Apple product like an iPhone is known to be top class and also unique as this is the brand that started a new style and a new type of structure for mobile.

You cannot open the phone so easily as you do on the other smartphones. However, most of the issues can be fixed ourselves. There have been many versions of iPhones over the years. Firstly, it is good to understand the SIM that is used for different iPhone Models

iPhones that use the normal SIM are iPhone 3GS, iPhone 3 and the first series of iPhones. Micro SIM is used on the models iPhone 4 and iPhone 4S and then came the Nano-SIM that can be used in all models above iPhone 6 and for the models iPhone 5s, iPhone 5c, and iPhone 5.

Once this is clear, you will know which SIM is on your iPhone without a doubt.

Solution for iPhone says no sim issue

Now here is the solution for the common question  how to fix when iPhone says no sim

  • Make sure that your current phone plan is active and working.
  • Make sure that your iPhone is updated to the latest version of iOS.
  • Now put on the airplane mode for a few seconds and then turn it off.
  • Once that is done, the phone must be restarted.
  • After the phone is restarted, go to Settings, tap on “General”, and then on “About”. Now check for the carrier settings update.

Try removing your SIM card from the SIM tray and then put it back. Just ensure that the SIM tray is closed properly. By now, your phone must start working fine without any SIM issues.

In case your issue is still not solved, then try using another SIM to test; sometimes, the SIM card may be defective. Your issue should be fixed by following the above-mentioned steps. In case you still see an alert about your SIM card, it is best to contact Apple’s support, and they will take it forward and fix the issue.

Continue Reading

Software

How To Watch Netflix Offline?

Published

on

Amazon launched offline videos somewhere around last September, so how could Netflix be lagging behind? Hence today just some hours ago they answered our age-old question, How To Download Movies On Netflix by officially launching Netflix “offline” feature.

Well, it’s not like an “offline” app or something, but it does let you watch series and movies offline, without requiring an active internet connection!

And the best part is, we got some of our most favorite series on the offline list. Including Stranger things, Breaking bad and lots more.

So today after years of desperate waiting and rumors, our prayers finally were answered by the Internet Gods (if they exist) and hence we now know how to record and download Netflix Movies/Episodes offline. So bottom line, now you can watch Netflix offline.

What’s Inside:-

  • What is Netflix offline?
  • What’s needed to watch Netflix offline?
  • How to watch Netflix offline?
  • Advanced features.
  • How to access the downloaded files?
  • How to delete downloaded videos?

What is Netflix Offline?

Here’s the official statement from the Netflix team about what exactly the Netflix offline thing does for you “many favorite streaming series and movies are already available for download, with more on the way.”.

So two things I can gather from this statement is:-

  • Not “all” the movies and series are available to download offline right away.
  • Some movies and series are available and more are being added, meaning soon almost the whole of the database or a majority of it should be available for offline download.

Series and Movies Included in the Netflix Offline Feature Right Now:-

  • Stranger Things
  • Breaking Bad
  • Orange Is the New Black.
  • Narcos
  • The Crown
  • You’ve Got Mad Men
  • Paddington and Minions
  • Kung Fu Panda 3
  • And over a dozen others.

So from this list itself, I can say that all the movies and series on the Netflix offline available for download feature would be worth our time.

What’s Needed to Watch Netflix Offline?

Well, it, of course, doesn’t support “all” the OS and devices, but the good news is I’m sure 99% of you on this page already meet the requirements unless of course, you own a 2002 smartphone. (Did they even exist back then?)

At the moment, the following operating systems are required:-

  • iOS 8 or 8+
  • Android 4.4.2 or later.

And of course, you’ll need to update your Netflix apps right now if you want to watch Netflix offline. How to download Netflix? 

How to Update your iOS app for Netflix?

  • Open “App Store”.
  • Tap on the “updates” menu.
  • Tap on “Netflix” in the menu and tap on “update”.

How To Watch Netflix Offline?

So okay finally down to the section you’ve all been eagerly waiting for. Here’s How to Record Netflix Streaming Videos officially and legally!

Just Sign-in into your app on your iOS or Android device.

Tap the options button, and you’d see an “Available for download” option right above your TV shows.

This screen holds all the series and movies which are available for offline downloading. All you’ve got to do is, choose them and then click on the download button.

You should already see the new popup there telling you that now you can download that specific movie/ series offline.

Done! Once you do that, the downloading process will begin and you’ll be united with your favorite shows momentarily (depending on your Internet connection!)

Quality Selection:-

Netflix already stirred the world up with it’s “watch offline” announcement no doubt, but they didn’t forget to add some additional perks.

If you tap on the [bbuttoon] and scroll down to the “app settings” option, You get to a “downloads” heading.

This is where you can specify what quality you want to download the video in. Currently, two download qualities are available:-

  • Standard:- The lower quality.
  • High:- The highest possible quality you can download the file in.

This comes in handy in two conditions specifically:-

  • If you have a lower disk-space on your cell, choosing a lower resolution would considerably bring down the size of the file, and hence you can enjoy your favorite shows without expanding your memory.
  • If you’re on a slower connection, bringing the resolution down also brings the size down, and the size in return speeds up the downloading process. Or at least, gets downloaded faster. It’s, of course, easier to download 200mbs rather than 1GB, right?

How to Watch a Downloaded File?

Just tap on the options button in your Netflix account, and you’d see “My downloads” button right there along with other options.

This is the section you need to go to in order to access your downloaded videos and play them.

How to Delete a Downloaded File?

Of course, keeping a file there after you’ve finished watching it isn’t wise, right? And as I’m writing this “How To Watch Netflix Offline” article anyway, I thought why not cover all the bases.

So well how would you delete a downloaded file?

Tap on the “Edit” button on the top-right corner of your “my downloads” section.

And then you’d see a red “X” button. Just tap on it and your video is gone!

Wrapping it Up:-

So yeah that was all I had on “How to Watch Netflix offline” folks. I made sure I covered almost all the possible aspects with “Netflix offline feature”.

But in case I missed something and you’re stuck, do let me know. Also, I wouldn’t mind if you decide to promote us by sharing this piece on your Social media profiles. (I’m sure your friends would always remember who bought them “Netflix offline” for the first time, right?) 

Continue Reading

Blogging

How to Transfer a Domain Name?

Published

on

How to sell a domain name

If you want to know how to transfer a domain name to another person? or to be more specific on how to transfer a domain name then you are at the right place.

So, without wasting any time further, let’s get started:

How to transfer a domain name?

Since Godaddy is one of the biggest domain registrars in this sphere. So, we will first see how to transfer a domain name to Godaddy from another registrar and how to transfer ownership of a domain name?

We have used Godaddy for illustration purposes. You will be glad to know that almost all the processes are pretty much the same for other registrars also. You just need to understand the basic concept. This way you will easily be able to transfer domains to any registrar.

So, let’s get started:

To Godaddy.

There are a few things that you should keep in your mind before proceeding forward and those are:

1) This method will work only if your domain extension is .com, .org or .net only. If you have any top-level domain (TLD’s) like .biz, .fr or others, then you will have to follow other methods.

2) Domain name transfer may take some time. So, your patience is much needed.

3) In general, you are not allowed to transfer your domain in the first 60 days time period starting from the date you purchased the domain. You are not able to update your contact information, first or last name of the registrant.

There are eight steps in the process. Some of the steps are quick and straightforward. So, let’s get started with the same:

The first four steps may be called preliminary or preparation steps which ensure the smooth domain transferring processes.

1) In this first step, you need to make sure that the domain which you are to transfer to your Godaddy account is not privately registered. Make sure to check this one.

2) In the second step, you need to unmark your domain name from your current registrar.

3) In this step, you need to visit whois.icann.org to ensure and verify that the contact information which you have provided is correct or not. Also, check that if your domain name is eligible for transfer or not.

4) In this final preparation step, you need to get an authorization or EPP code from your current registrar.

With these preliminary preparation steps, your domain name is now ready for the actual domain transfer process and this you will have to look for our next four phases. These four stages will be the one which will contribute to the domain transfer process.

5) In this step, you will have to purchase a domain name transfer from Godaddy.

6) Now, you will have to wait for the email from Godaddy that will contain two purchase codes. We will make use of the codes in the later part of this transfer process.

7) Now, you will have to use the authorization or the EPP code which you have managed to get in step 4 of the preparation part. You need to enter the EPP code along with the two purchase codes which you have got through the Godaddy mail in the previous step. This will approve the domain name transfer.

Once done with this, you are just a step away from transferring the domain name to GoDaddy.

8) This final step is concerned with monitoring the status of your domain transfer process.

It is advised to be patient because the transfer process may take up to seven business days starting from the date on which you entered the approval codes.

Once the transfer is complete, Godaddy will make you aware of the same. Also, you may face some downtime. So, do not panic and be patient.

From Godaddy.

The steps are pretty much the same. But for the sake of convenience lets have a quick glance over the process once again.

1) Check your administrative contact information. You may also need to cancel your protected registration or private registration service.

2) Now, you will need to unlock your domain name from the Godaddy administrative dashboard. Just do the required and proceed with the next steps.

3) You need to get an authorization code from Godaddy which you will need on a later part of the process. Some of the registrars do not require this. So, make a check for the prerequisites.

4) Now, you need to authorize the domain name transfer process on your new domain registrar.

5) The registry will notify the Godaddy system, and they will mail you with further instructions. You only need to follow the onscreen instructions as it will do the needful for you.

Kindly take note that, if somehow you do not accept or deny the transfer request then Godaddy will automatically transfer the domain name within five days. Kindly, pay heed to this and take appropriate actions.

6) The registry will also notify your new registrar about the transfer.

7) Once the transfer is complete, you will be informed by email. As we have already told you that domain transfer between registrars may take up to seven working days. So, your patience is much needed.

Here are some quick tips for you regarding how to transfer a domain name to another registrar?
1) Make sure that you are equipped with any alternative email ID as you are more likely to lose the access email service in correspondence to your domain name.

2) As we have already mentioned that you are not allowed to transfer the domain name within the first 60 days either from the purchase date or the transfer date. So, make sure to pay heed to this.

3) Make sure to read the support pages of your new registrar and in any case of haphazard, feel free to reach them via the customer support.


So, this was all about how to transfer a domain name? Do we hope that by making use of the information provided here, you will be able to know How to transfer a domain name to someone else? 

If you are aware of any methods apart from this, then do let us know through the comments section below. Moreover, if you liked this article on “How to transfer a domain name?” Then do share it socially.

Thank you for crossing by and giving it an enjoyable read.

Continue Reading

Tech

How to Create a Pie Chart in Excel?

Published

on

Creating a pie chart in Excel is one of the most used functions of this application. But let me tell you a secret, I really hate this feature!

I mean when I was a kid, I spent hours and hours to do all the calculations and then make the pie chart. My drawing was very bad that meant I spent countless hours trying to make a perfect circle.

And then let’s just not talk about making the lines of the perfect angle inside. And then when I grew up I thought it was the time to show my superhuman skills of making a perfect pie chart.

But then Microsoft made Excel pie charts means all my skills are of no use now (I hate you! Bill). Anyway, Pie Charts in Excel is one of the most amazing features of this app.

We can create not only the perfect pie charts in terms of Angles but also they are great in terms of looks. So today we have brought you a complete tutorial on how to create a pie chart in Excel?

After going through this article, you will be able to make a pie chart.

What is a Pie Chart In Excel?

Before knowing how to make a pie chart in excel, you need to know what the Pie Chart actually is. Well, in simple words pie charts is a chart to display data relative to other data in a circle. Each set of data has his own value or slice in the circle (or Pie).

Now Microsoft had taken this and changed the approach. Previously you had to create a pie chart with your hand, and you had to calculate the size/angle of each slice manually.

Now you can just enter the primary values of the chart and then create a flashing attractive pie chart within 5 minutes without any calculations and drawing skills.

Uses of Pie Chart in Excel.

So now you know what a pie chart is so it’s time to know how can you use it. It’s a basic human behavior that we understand the things we can see more easily rather than the things we have to read and understand.

So if there are lots of data which are related to each other and you want to explain it to somebody else. Then creating a pie chart is the best option.

For example, if your boss gives $1000 each month to spend on staff. And at the end of the month, he wants to know how you spent the money.

Now if you’ll try to explain to him that you spend $50 on tea, $10 on buying pens, $10 on buying paper, etc. then he might order to through you out of the office for confusing him with lots of data.

But at the same time if you know how to create a chart in Excel and then show it to your boss then it will be far more easy for him to understand it.

How to create a pie chart in Excel?

So now you have enough knowledge of Pie Chart, and it’s usages so now it’s time to learn how to create a pie chart using Excel. Relax it’s not rocket science, in fact, you can create a pie chart within 5 minutes. Just follow the following steps to do so-

Step #1: Enter the necessary data.

For creating a pie chart you first need to enter a set of data in the Excel Spreadsheet. Type the names of all categories in one cell range and the value associated with them in the other cell range just in front of the related categories.

For example, we are writing the name of animals found in an area and their population in the other category. See the image below for better understanding:

Step #2: Select all the necessary data.

Once you have entered the necessary categories and their values, you’ll need to select them. Just use your mouse and select all the cells you want to use in your Excel Pie Chart.

Note that you should not leave any line blank while writing the data.

Step #3: Adding the pie chart.

Once you have entered and selected the values, now it’s time to add the much-awaited pie chart. Click on the Insert tab and choose ‘Pie’ from the options that appear.

Once you click on it, a new pop-up will appear, it will contain all the styles you can use for your pie chart. From there select your pie chart. For this example, we are selecting the 2D pie chart which is the first option from the pop-up.


Congrats that’s all you have to do. Your pie chart will now automatically appear in the Spreadsheet as seen in the below picture.

Now if you like, you can play with your pie chart. You can click on any slice of the pie and then take it away from the chart. This will be very helpful while giving a presentation. You can take the slice out of the circle which you are trying to explain. So people will easily understand which slice you are talking about.

Pie chart Frequently Asked Questions

Pie charts are the most commonly used features for business, so obviously people always have what-if questions or how to question it. So we have created a handy faq section to answer questions about pie charts-

Q: I entered a wrong before creating the pie chart excel?

It often happens that you notice that you have entered a value wrongly after creating a pie chart. Well, don’t worry. You won’t have to create the whole pie chart again. Rather than you can just change the numbers, you entered in the spreadsheet, and the pie chart will be updated automatically.

Q: I can’t find the pie option in Excel 2013?

With the 2013 version of Microsoft Excel, Windows have made big changes in the UI section. So if you are used to working with the older versions, you may find it hard to locate the pie option.

But don’t worry it’s just there. Once you open the Insert menu, you can find the pie options there. For your ease, we have marked out the pie option in the picture below-

Q: What is the design tab and how to find it?

A design tab is a unique option in the Excel 2013 version. You can see it on the menu above after you have inserted the pie chart in it. Here is a quick look at all the options available in the design tab-

  • Add Chart Element- it allows you to change the chart title, legend or data labels.
  • Quick Layouts- they are different preset charts. You can use any of them if you don’t want to change every part of chart one by one.
  • Change Colors-it allows you to change the colors in your chart.

Wrap up

So this was the complete tutorial on how to create a pie chart in Excel? Do you still have any questions in your mind? Do tell us in the comment box.

Stay tuned and thank you for giving it a read.

Continue Reading

Trending