Web
Analytics
Connect with us

Tech

How to Turn on Bluetooth in Windows 10

Published

on

How-to-Turn-on-Bluetooth-in-Windows-10

Microsoft has succeeded in creating a huge buzz around their new operating system, Windows 10. You might have already upgraded to it. Or else you may be waiting your turn patiently to get your hands on the update!

The biggest step from Microsoft is that Windows 10 is a free upgrade. Even, pirated versions of Windows have received it as a free upgrade.

Anyway, I hope that you were lucky enough to get Windows 10 installed on your computer. So here, I am explaining how you can turn on Bluetooth in the latest iteration of Windows. Before we get to that, though, let me just tell you about some of the unique features that Windows 10 has up its sleeve.

Features of Windows 10

How-to-Turn-on-Bluetooth-in-Windows-10

#1. Cortana: – Do you know Siri? It is a built-in intelligent assistant for iOS. Cortana is a similar type of app not only available for Windows Phone platform, but also for PC.

#2. Edge: – Gone is the old and hardly used Internet Explorer. Edge is Microsoft's new browser, and boy is it slick!

#3. The Return of Start Menu: – Start menu has made a comeback with Windows 10.

#4. Virtual Desktop: – You can operate multiple desktops even with a single monitor setup! Windows 10 offers the virtual desktop facility for that.

#5. Windowed System Apps: – Some of Windows’s default apps can’t be run in windowed mode on Windows 8. But no such worries with Windows 10. You can run inbuilt apps in windowed mode.

There are a lot more to explore, so go ahead have fun with your new operating system! You can even connect two laptops wirelessly. Here are steps to connect two laptops wirelessly.

Now to the subject at hand!

Turn on Bluetooth in Windows 10

turn-on-bluetooth

Every laptop has Bluetooth connectivity option nowadays. But, you will need an external adapter for most PCs. Bluetooth needs no introduction. Ever since its inception, Bluetooth has made file transfers between two supported devices a breeze.

I don't really mean that you can send a 1 GB file in a matter of seconds. But at its time of arrival, Bluetooth was one of the best data transfer methods readily available to the public!

The intrusion of Wi- Fi into our life never influenced the popularity of Bluetooth. If you want to transfer a file from an old model mobile, there will be no other solution than Bluetooth. That’s why mobile manufacturers keep on including that feature unlike infrared.

You can proceed with the following methods to turn on Bluetooth for your laptop as well as PC. Before going to it, check whether you have the requirements or not.

There are a lot of Windows 10 updates that keep on coming again and again. Although they are legit Windows updates if you are not interested in latest updates, you can disable Windows 10 updates.

Prerequisites

#1. A PC or Laptop with Windows 10 installed (I am explaining the method for Windows 10 only).

#2. For Laptop, make sure that it comes with Bluetooth support. In the case of no- Bluetooth PCs and laptops, plug in an external adaptor (cheaply available).

#3. Don’t forget to install compatible drivers.

Steps to Turn on Bluetooth on Windows 10

Before you dive into how to turn on Bluetooth,  make sure that you have all the above requirements.

#1. There is a settings option in Windows 10. You can open it via many methods. The easier way is pressing Win key + I simultaneously. Or you can also find settings in the Start menu.

If you want a change, use the Search the web and Windows box. Type settings there and press enter.

#2. Now, that you have opened the Settings window. The next thing is choosing Devices. Most probably, this option lies secondly on the Settings window.

turn-on-bluetooth

 

#3. You will get another window like the image given below. Almost, six options are there in the left panel such as Printers& Scanners, Connected devices, etc.

turn-on-bluetooth

#4. We have to select the third option, Bluetooth. Here, you can see all the options to control your Bluetooth adapter on the computer.

#5. Check out the first option. If your Bluetooth adapter is not active, you will see Off under Bluetooth. Click on the small bar beside it. That’s all. Bluetooth for computer becomes active.

#6. After that, you can see visible devices under Bluetooth option. Select and click on one to get paired. You will be asked to match passcodes. Click on Yes.

Then, you can start transferring files both ways between your computer and phone or what gadget you will be connecting.

It is as simple as that. I think you will not disturb Google with ‘How to Turn On Bluetooth on Windows 10’ anymore.

Haven’t You Turned on Bluetooth Yet?

I have given you some easy to do steps to turn on Bluetooth on your Windows 10 computer. As you can see, it is not a tough row to hoe.

If you face any issue in turning on Bluetooth, make sure that you have correctly installed the drivers, and your system does support Bluetooth.

You may find it difficult to see your device name on the computer. In such a scenario, just check the visibility setting of the phone. Most probably, you haven’t made the device visible to all.

Just in case if your windows computer is getting slow, you can easily boost the Windows 10 speed using simple hacks. Here is how to make Windows 10 faster.

Or if you face any other issues regarding the same, do shoot a comment using the comment box below this post. Don’t forget to share this with your buddies.

Rahul is a freelance writer and blogger from India. He is an avid reader who finds immense pleasure in creating cool pieces of content.

Continue Reading
11 Comments

11 Comments

  1. Tony

    November 28, 2015 at 7:23 pm

    After the Win 10 upgrade, the Bluetooth option is no linger available. I have gone through the steps outlined in your tutorial (and many others as well) and the option is not even listed. I upgraded to Win 10 from Win 7, where the Bluetooth worked flawlessly. Please help.

    • Amartya Baidya

      November 28, 2015 at 8:09 pm

      Hi, this can be sometimes caused by you not having the correct Bluetooth drivers for your laptop. Please make sure you have the most current and up-to-date drivers for your laptop so that the Bluetooth module can work flawlessly.

  2. DeeAnna

    December 15, 2015 at 3:16 pm

    i didnt have the bluetooth option in action center until this update. now that it is there i still cant do any thing with it.i dont have the bluetooth option in my devices so what should i do

    • Amartya Baidya

      December 15, 2015 at 5:45 pm

      You will need devices with Bluetooth for this to work

  3. Jeanie Jones Puckett

    January 1, 2016 at 8:22 am

    Mine calls it “radios” – I think it’s the same thing?

  4. Lisa Massey

    January 24, 2016 at 3:47 pm

    HELP!….I changed my laptop over to Win 10 months ago…but for some reason, I can’t find my Bluetooth ANYWHERE….my laptop is Bluetooth ready….but I can’t seem to find it….been trying for 3 days…please help me…

  5. Renetter

    January 31, 2016 at 3:39 am

    There is no Bluetooth in the list. How do I get Bluetooth in the list? You said make sure you have the correct Bluetooth drivers, but you forgot to say how you do that?

    • Amartya Baidya

      January 31, 2016 at 1:40 pm

      Check your device manufacturer’s website and under Drivers for Windows 10, you should find drivers for Bluetooth, Wifi and Ethernet. Sometimes they are categorised together as Networking, sometimes you have them as two packs of Wired and Wireless Drivers and other times they are there as individual drivers. We didn’t include links or instructions because there are so many ways that different companies choose to package their drivers.

  6. Diane

    June 18, 2016 at 11:58 am

    My drivers are up to date, but there still is no Bluetooth Option in the Devices list in Windows 10. If you could help, I would appreciate it!

  7. vijay

    August 23, 2016 at 1:17 pm

    unable to turn on blue tooth

  8. bex

    October 1, 2016 at 10:23 pm

    I had this problem. Go to Connected devices then Device Manager and click on the Bluetooth symbol. Update Bluetooth software and it comes straight on and back on the settings menu! Yay!

Leave a Reply

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

Tech

How to Merge Word Documents

Published

on

Have you ever wondered how to merge word documents? You might have! In our daily life, the situation often occurs when it feels the need for combining the word documents into one.

If you have been using MS word, you probably have felt the need of merging up more than one document into a single word file. For instance, if you write a thesis, dissertation or book, you will create all the pages separately, like page 1, page 2 and so on.

But after, when you are done writing up all the pages and want to merge them up in one single document, how would you do that? How would you merge word documents? Probably, you will create a new document and copy all the pages one by one page and paste them into the chief doc (main document).

But let me tell you this is absolutely a wrong way of merging up the documents. This article explains how to combine Word documents into one document.

So let's get started, and learn how to merge documents in word. 

How to Merge Word Documents

To merge up the files, you can use two ways. One by copy-pasting as I said above and another way is by creating a main document and combining them.

In this article, we will let you know to merge up the multiple files into one file in almost all the versions of MS word. No matter you use MS word 2007 or 2010, you will get to learn the procedure for all. Just keep reading the article until the end.

In order to provide you the tutorial with screenshots, I have created three-word file name file 1, file 2 and file 3. And the main file that is named with the Main file. I will merge up the file, file 1, file 2, and file 3 into the principal file that is the Main file.

Ok, so here go our guide on how to merge two-word documents. The steps are given below. Follow all the steps carefully and see how the multi-files are merged into one.

But before moving to the guide make sure to follow some prerequisites given below.

  • First of all, make sure the files you have saved are in the same extension.
  • Also, the files that you are up to merge should be in a particular order. Word will merge your files in alphanumerical order.

For example, if you have named your files as file 1 introduction, file 2 projects, and file 3 docs, then the word will combine all the files in the same order.

But if you have named your files as an introduction, projects, and docs, then the files will be sorted in alphabetical order. And the order would be docs, introduction, project.

So if you want your files to merge in some sequence, then you will have to save them with a particular order or sequence.

How to combine word documents in Word 2007 or later

The following procedure is for MS Word 2007 and later versions. If you own some older version of MS office then still not to worry, below I have covered that also.

  • In MS Word, go to the Insert menu from the top menu bar.
  • In the Insert tab, at the rightmost side, you will see an option, Object. Click on that. Don't click on the object, but on the small arrow just beside the object option.
  • After you click on the Object, you will see two options, Object.. and Text from the file.  See the screenshot below.
  • In order to insert the file, you will need to choose the second option that is Text from the file. As sooner you click on the option a dialogue box will open. Here you will need to select the files you want to merge.

For instance, I am selecting the files named file 1, file 2 and file 3. See the screenshot below.

  • After selecting all the files you want to merge you will have to click on the insert button as shown in the above screenshot.
  • And you are done! After clicking on the insert button, all the files you selected would get merged into the main document. Now save the main file at the location you want.

This is how we merge a document to the current file or multi documents into one single file.

If you have a single file that you want to merge in the current file, then you need to open the current file first and then select the file you want to merge by going to the Text from file option.

And if you want to merge multi-files as said above, then you can press CTRL key to select multi-files in one go.

If you have an older version of MS office like 2003 or so, then the procedure of merging file would be a slight different from the previous one. The procedure to merge files in MS word 2003 is given below.

  • First of all, go to the Tools menu from the top menu bar. Here you will need to select the Compare and Merge Documents option. See the screen mentioned below.
  • When you click on the Compare and Merge Documents option, you will see, a dialogue box will open. Here you have to select the files you want to merge.
  • open the files by clicking on them and click on Insert as shown in the below screenshot.
  • That's it. After you click on the insert option, you will see all the selected files will be opened up in the Mian MS word file.
  • Now save the file with the new name at any location you want.

Isn't merging files in MS word is easy? Let me know your views on the guide and the procedure I have mentioned. If you have any other way other than the mentioned procedure do let us know.

Also, do drop your comments and views regarding the guide on how to merge word documents. In the case of any confusion, you can ask them without any hesitation.

If you find the article useful share it with your friends and relative.

Continue Reading

Tech

How to Find Someones IP Address?

Published

on

Ever wanted to track someone’s IP address? If it is a yes from your side, then this article is for you only.

In this article, we will tell you how to find someone's IP address using different methods. After going through this article, you will surely be able to find the IP address of any website or any email sender

What is an IP address?

If you are wondering that what is IP address then you need not worry about it. We will tell you what it is and how to find IP address. An IP address looks something like this.

IP stands for Internet Protocol. It is basically a unique set of numbers separated by a full stop and used for communicating over a network.
IP addresses are quite an important aspect of internet systems and are widely used.

How to find someone's IP address?

So, without wasting any time further, let’s locate IP address:

Method 1: Using the Command Prompt.

If you are to find the IP address of a website, then this section is going to help you a lot. Additionally, having a Windows operating system is one of the prerequisites because you won’t be able to access command prompt in any other OS. So, let’s get started:

Step #1: The first step is concerned around launching the command prompt with administrative privileges.  To do this, all that you need is to type “cmd” without quotes at the run or start section. Now, right-click on it and select “Run as administrator”. This step ensures that you have administrative privileges to do the required.

However, we found that even without any administrative rights, the command prompt is able to tell the IP address of the websites. So, an administrative right becomes an optional thing. Anyways, this won’t do any harm, and it’s better to be on the safer side.

Step #2: Now, you need to ping the URL of the website of which you want to find the IP address. For this, you will have to type “ping your URL” without quotes. Replace your URL with the website of which you find the IP address. Say, like if we wish to find the IP address of “Knowledge Cage” then the command would look like “ping www.howdiary.com.” Once you have typed the desired, then the action which is required is to hit enter.

The moment you hit enter, the command prompt will start fetching the requested data and within no time, you will have the IP address of the website.

The IP address will appear next to the website name. The screen will also display the total pinging time it took to fetch the result.
Using this method, you can easily find the IP address of any website.

Method 2: Find the IP address of an email sender.

Gmail.

If you are using Gmail for the email purposes and want to find the IP address of the sender, then you should definitely have a look at this.

Step #1: Log in to your Gmail account using the corresponding credentials.

Step #2: Once you are at the email dashboard then you now need to open the mail of the person of which you want to find the IP address.

Step #3: After successfully executing step #3, you now need to click on the down arrow icon which is positioned just beside the reply icon. Clicking on it will open a menu for you from which you have to select the “Show Original” option.

Step #4: The previous step will open a new tab for you from which you have to look for the “Received” section. The IP address of the sender will be located in front of it.

Yahoo!

In case, if you are using Yahoo mail services then this section will be of some help for you.

Step #1: Log in to the Yahoo! Mail by using appropriate credentials. Doing this will open the Yahoo mail dashboard for you.

Step #2: Now, navigate to the folder on which you have stored the mail of which you want to find the sender’s IP address. The folder can be your inbox, drafts, starred or others.

Step #3: Now, navigate for the email which you want to track and once found, click on it. The moments, it opens, you are required to click on the “More” option. This will open a dropdown menu for you. From the dropdown menu, you need to select “View Full Header”.

Step #4: Now, from the subsequent window which follows up as a result of your recent activity, you need to scroll down for Received: from. It will be followed up by the IP address written between the square brackets [].
This way you can easily locate the IP address of any email-sender in Yahoo!

Hotmail.

Hotmail is yet another email client. So, if you are a user of this email service, then you can also track the IP address of the sender.

Step #1: The very first step is quite obvious. All that you need to get started is to log on to your Hotmail account by entering the corresponding credentials. This will obviously open up your account dashboard.

Step #2: Now, you need to click on the “Inbox” link which is usually positioned at the left.

Step #3: Now, you are required to find the email which you want to track and right-click on it. You will get a menu from which you are required to select “view message source.”

Step #4: If you have executed everything well then by now, you would have the email headers with you on your screen. You may find the IP address of the sender in front of “X-originating-IP.” If that doesn’t work for you, then you should consider looking for the Receiver: From section.

Following this route, you can easily find the IP address of any email sender.

This brought us to the end of this article “How to find someone's IP address”.

We hope that you may find this article worthy enough to share it with your peers.
What methods other than those you use for finding someone’s IP address? Do tell us via the comments section. We would love to hear from you.
See you soon.

Continue Reading

Tech

How to Find Full Length Movies on YouTube?

Published

on

How to Make a Playlist on YouTube

We all prefer watching good movies at home without going out of our house, without getting ready by putting on good clothes and without buying a cinema ticket.

It’s much comfortable to wear our loose pajamas and to lie on our bed, inside a blanket with some snacks and drinks and watching free full-length movies online.

But the question arises where to watch movies online? YouTube along with all the other various streaming websites has become a great option when it comes to free full-length movies. Let's be honest that many of us are not aware of how to find full movies on YouTube.

So this article deals with the simple ways of which you can find full-length movies on YouTube. So let’s start:

But first, we need to know to understand what YouTube is? Though it is quite evident that you might be knowing about YouTube for the sake of comprehension, we will tell you what it is.

YouTube is known as the largest online video-sharing website that provides unique features to its billions of subscribers. You may search for movies, trailers of upcoming films, highlights of soccer or any other sport and many more things.

How to Watch Full Movies on YouTube

Sometimes, it becomes prolonged to find full movies on YouTube because of the daily increase of uploaded videos on YouTube by different channels.

Now moving on with the ways with which you can watch YouTube full-length movies or YouTube movies full:

Method #1: By using the basic structure of YouTube.

Step #1: The very first thing that you require doing is to open a new tab in your browser and then go to the www.YouTube.com

Step #2: Now when you reach the YouTube page. Click on the search bar that is on top of the page and writes the name of the movie which you are looking for.

  • Now use the keyword “Full-length movie” or “Full movie” with the film name.
  • Then just press the “Enter” button or click on “Search.”
  • Sometimes you might find the film and sometimes not because the film you searched for is recently released and nobody has uploaded it.

Step #3: After the above steps your search result will show you a list of videos stored on YouTube. This list contains videos of different lengths and types. These results may be short trailers, video songs or YouTube full-length movies according to your searching words. So now you can “filter” your search to be more specific in finding YouTube free full movies.

  • To filter your search, you need to go to the Search bar and look for the “Filter” tab. Click on the tab and you’ll see different search preferences there like date, type, duration, sort by, etc.
  • Now if you want to select the result on the basis of length then click the long option under duration. This will result in videos that are more than 20 minutes in length.
  • Click on the Search button or press Enter. The results will now show movies of full length that you have searched for.
  • Check the views, ratings and other information of videos before watching or downloading YouTube movies.

Step #4:  In place of adding filters after you searched for something, you can filter the results inside the Search Bar only.

You can write down the title and then add a comma and then write the name of the movie. Similarly, you can search for movies by actors, actress, director, and may others. If you are searching for a film with Tom Cruise, then you will type “Tom Cruise, movie”- insert a comma before the word film.

Method #2: By subscribing to the movie channels on YouTube.

Step #1: One must have a YouTube account in order to subscribe. To log in to your YouTube account, you can use your Gmail address and password.

Step #2:  To search for the movie channels on YouTube you can type “free full movies” or “ free full-length movies” in the search bar and then add a filter to the search.

  • You can find a “Result type” option below the Filter tab. Then select “Channels” under the “Result type” and now you can get the list of all the movie channels.

Step #3: Now go through the list of all movie channels that your search has generated. When you get one that you like then just click the “Subscribe” button.

  • By going to the movie section of YouTube

You can now find a movie section on the left side of the main page of YouTube. If this does not appear as an option, then you can just add a slash bar after the website’s address and write movies. This will take you to the film section on YouTube.

Here you can find the latest and best collections of movies recommended by YouTube.

If you are not willing to search the YouTube movies manually then this the best option for finding a full-length movie online.

Method #3: By using external sources.

The best way is to make complete use of the service called Zero Dollar Movies that provides you with the instant search feature.

Step #1: Go to “Zerodollarmovies.com.”

Step #2: In the search box enter the title of the movie and press Enter.

Step #3: Refine your search by selecting the release year of the movie, language of the film. You can find movies in different languages.

Let’s wrap it up.

This let's wrap it up section brings us to the end of this tutorial cum guide on “How to find free full-length movies online” We hope that we were efficient enough to satisfy your curiosity about this topic.

We firmly believe that we have left no stone unturned while getting into the nitty-gritty of the topic and making you understand the entire concept of it. But if you still have any query regarding “How to find YouTube free full movies?” then feel free to drop your query via comments below. We will try our level best to resolve that.

Moreover, if you found this article helpful and worthy, do show your love by sharing it socially.
Stay tuned and keep visiting.

Continue Reading

Tech

How to Check If a Website is Down

Published

on

How to Check If a Website Is Down

Everyone bats an eye if a popular website goes down. Social media trends gain momentum, and everyone keeps on posting about the same that is this site down or check if the website is down. One popular question that arises in such a situation is that is it down for everyone or just me or is the website up or down. 

So, if you have ever encountered any kind of such stuffs then you would want to know how to check if a website is down? This article will put a halt on your quest of finding the answer for the same.

This article will tell you how to check if a website is down using some simple and straightforward methods.
So, let's get started:

How to check if a website is down?

1) Down Right Now.

Down Right Now is a popular web-based service that helps you monitor whether a website is down or not. They are backed up or powered by various user reports and the official announcements made by the sites itself.

You can check whether a popular website is up or down along with the possible reasons for that. The popular reasons might be “Possible service trouble”, “Likely service disruption”. You will also get to know about the service unavailability over the past 24 hours through the graphs. Additionally, you can also follow their official accounts to stay updated with the notifications.

The only limitation which is associated with this website is that it displays data of a handful of websites only that is only selected websites are displayed over there. For frequent information, you need to refresh the web page manually. There is no such automated feature that may help you to do this. Above all, the website design is somewhat chaotic and hazy.

This website serves well if you want to check the status of popular websites like Facebook, Twitter or others. However, if you want to know about a not so popular website then you are required to seek somewhere else.

2: Is it Down Right Now.


Yet another great platform to check whether a website is down or not. Unlike the previously mentioned website, this platform allows you to check the status of any specific website. All that you have to do is to enter the domain which you want to check at the specific field and click on Check. Within no time, you will have the status of the website.

Along with this feature, is it down right now also displays the list of popular websites with their corresponding statuses.  The extension of this platform is also available which lets you check the status of any website through your browser's toolbar. For this, you will have to integrate the extension of this website on your browser. Then only, you will be able to use this facility.

This website is also reachable through a short URL. It also displays the list of recently checked websites along with popular websites. The data is up to the minute and hence, can be considered accurate as per time dimensions are considered.

As compared to down right now, this website is pretty slow but is extremely useful if you need to check the status of any custom domain.

3: Down for everyone or just me.

How to Check If a Website Is Down


Many times, all that you want to know is just a straightforward answer for whether a website is down for everyone or just me. If this is the case then this platform is exactly for you.

This platform will simply tell you whether a website is up or not. No cherry toppings, no garnishing, just simple and straightforward answer. You can also reach this site via a short URL and that is IsUp.me. This way you need not type the long URL each and every time.

To make use of this platform all that you require is to enter the name of the domain on which you want to perform the check. Once you have done that then now you require clicking on or just me? Hyperlink.

This will land you to a web page where you will be provided with an answer to your query.
Down for everyone or just me is quite a good platform for you if you are not concerned with the extra details about the website. All that you want to know is the up and down status of the website.

4: Just Down for me.


This platform serves the same purpose as all others but it also comes up with some exclusive features which are missing from the previous ones.

The most prominent feature which makes it stand out from the crowd is that it also equips you with the IP address of the website from which it was last accessed.

This feature comes handy as you can now use the IP address to access the website instead of the domain.

It also shows the sites went recently down, frequently checked and recently checked.

As per the reviews available, the cons associated with these websites are a matter of issue. You may sometimes face lag. The site design is not so good and clean. Sometimes, you may have to enter and send the query multiple times.

This website is quite good if you want to get access to the website anyhow as Just down for me can equip you with the last accessed IP address of the website. You should know that it seems like that the results are not that authentic for the US users but if you are an international user then this may serve you well.

This brought us to the end of this article on “How to check if a website is down?“. We hope that this article has resulted at an end of your quest regarding the same.

Is my website down? or Is the website down? or Down for me or everyone? if this question has ever bothered you then this article must have solved your problem. If you liked this article then do not forget to share it among your peers.

Thank you for crossing by.

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