Web
Analytics
Connect with us

Tutorials

How to Make a Bar Graph in Excel?

Published

on

If you have been reading our tutorials, you must know that in one of our previous articles, we have provided some of the guides on Excel programs. Probably you would be aware of that. If you have missed out our tutorial on excel program do read out them. You can click here for directly navigating to the excel tutorials.

One of such tutorials was how to create charts in excel. And today the guide we are going to provide is quite similar to that guide. The tutorial we are going to provide today is How to make a bar graph in excel.

If you struggle to create a bar graph in excel, then probably the article is written for you. Since this article is going to describe the complete procedure to make a bar graph in excel. So, let's begin the guide how to make a graph in excel. There are other ways to represent the numerical data in an attractive manner like Charts. Here is how to create a Chart in Excel.

How to Make a Bar Graph in Excel

The today's guide how to make a graph on excel is thoroughly going to describe all the steps that too with screenshots. I am quite, sure after reading the article, there won't be any doubt remain regarding the procedure of creating the bar in excel.

The tutorial on how to make graphs in excel in given below. Let's head over it and learn how to graph on excel. 

The procedure for creating graphs or charts in excel is same in almost all the versions of excel program. But the screenshots we have provided below are taken from the MS excel 2007 program.

Step 1: First of all, launch the excel program to your system and fill out the necessary data you want to make a bar graph of. Check out the below screenshot.

In the image I have mentioned below, I have added some random name and the dates. You will have to feed the entries as per your need and requirements. Check out the screenshot below.

How-to-make-a-bar-graph-in-excel

Step 2: After you have entered all the data in the excel program, select them. You have to select the data you want to create the bar graph of. If you want to create the bar graph of all the data entered in the sheet, select all.

Step 3: Once done with the above step, I mean highlighting the area(Row/Column) click on the Insert menu from the menu bar.

If you notice, after clicking on the insert menu, many options has started appearing. Like Columns, pie, bar, area, scatter etc. Here, you have to click on the bar option. As you are here to learn how to make a bar graph. Check out the screenshot I have taken for you. If you are confused, this screenshot will help you in understanding better.

 make-a-bar-graph

Step 4: Here, simply click on the bar option. After clicking on the bar, a drop down will open up where you will see a list of bar graphs. All you will have to do is select the type you want to create the graph of.

As sooner, you will click on the graph, excel will prepare the bar graph for the selected area. And you are done. Check out the below screenshot I have mentioned.

 make-a-bar-graph

So this is how we can create graphs in excel. As I said above creating graphs or charts in excel are just a few clicks step. I hope after reading the steps you must have got that, how easy is to create a graph in excel is.

Well, this was about creating the simple bar graph in excel. But if you are not satisfied with the color or type, you can change that too. Yes in the design section, you can change the design and color of the graph as per your choice.

When you click on the design option you will see an image like I have mentioned below. Have a look on that.

how-to-make-a-bar-graph

Remember you won't be able to see the design option at the menu bar until you select the created bar graph. When you click on the bar graph, then only the option would appear on the menu bar under the chart tools section.

And you can also change the bar style by clicking on the chart style option at the right-hand side of the screen. You can apply any kinda chart type to your bar graph. But I will suggest you to keep it simple to give the even more official look.

Moreover, you can also change the chart type. To do that you will have to click on the change chart type option from the top left side of the screen. When you click on the change chart type option you will see a drop down will pop up. Check the image below.

how-to-make-a-graph-in-excel

In the above image,  I have marked the change chart type option with the red rectangle and the types of charts with a yellow rectangle. All you have to do is click on any of them as per your need and the suitability.

You can also switch columns and rows by clicking on the Switch Row/Column option. You will find this option just beside the change chart type optionCheck out the below screenshot if you are unable to find the option.

So this was only about how to make a bar graph in excel. I am expecting you have liked and enjoyed the guide. And have found the purpose for landing on this page.

Excel is indeed a great application program that is being used by many people for maintaining numerical data. You can easily divide numbers in excel, you can find average on Excel and moreover, you can also compare two excel files that also helps in finding the duplicate data.

In the case of any confusion do drop your comment below. Or if you have any suggestion then also you can share with us.

The procedure I mentioned above was about creating the bar graph in excel. But if you want to create a chart or scatter plot in excel, then also you will have to follow all the steps again. But instead of going to bar option you will have to go to the chart or scatter plot options as per the demand.

If you enjoyed our today's tutorial, share it on your social media platforms. We will highly appreciate that.

Sonam is an IT engineer by education and passionate freelance writer/blogger by profession. She is a tech enthusiast and loves to read and write about technology. Her hobbies include reading, watching TV, delving into new things and creating interesting content to help people with all things tech!!

Continue Reading
Click to comment

Leave a Reply

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

Social Media

How To Delete Oovoo Account

Published

on

In the technology epoch every day we are introduced with a new application. Where every next app come along with some better features. Each app has something better than the previous one.

Skype, WhatsApp, Instagram, Kik and lot more apps are there which are equally popular among the populace. Similarly, one of these apps is Oovoo. Although, it's not as popular as other mentioned apps, it's indeed a feature-rich app.

Oovoo is a video chat and messaging application that facilitate instant messaging, video and audio calls. This app is similar in some respects to Microsoft's Skype. And the best part of this app is, you can video chat with up to 12 people simultaneously.

Oovoo is available for iPhone, iPod, iPads, and Androids. You can also use OoVoo on your system (MAC or PC).

However, many of us might not be familiar with the app but one who has been using it are loving it! Most of the Oovoo users are happy with its service.

But if you don't like the app or want to delete it then this article will help you to learn how to delete Oovoo account in easy steps.

How to Delete Oovoo Account

If you don't want to use Oovoo anymore then this article might assist you. Read out the article and learn the procedure to delete the Oovoo account. Below, I have compiled a step by step guide to making it easier for you.

To delete the Oovoo account, follow the below steps.

No matter if you use Oovoo on PC or mobile, this article is written for all the users of Oovoo. Below, I've shared the method to delete Oovoo account from the mobile device as well as from PC.

Starting the guide for mobile users first. The steps are given below.

How to Delete an Oovoo account on Mobile.

The first and most important step which you need to follow before moving to the deleting procedure is removing all your personal details from the app.

Delete all the information you have furnished in the app and make yourself unreachable.

Once done, you are ready to terminate your account. Now follow the next step.

  •  Open Oovoo app on your phone or tablet.
  •  Now, enter the credentials and sign into the app.
  • Once you are signed in, touch your Display Name at the top of the screen. Tap on edit icon and type Closed in the display name field.
  • Now following the previous step, tap on your profile photo and then, tap over the Settings option from the drop-down menu.
  • Under the Settings option, tap on the Privacy & Security. Here what you need to do is change your search profile setting so that no one can search your profile. To do so, simply change search preferences to No one.
  • Now tap on the profile photo and remove it.
  • That's all. After a day or two, your account would be deleted permanently. Now all you need to do is remove and uninstall the app from your device so that, you won't mistakenly open it.

How to delete your Oovoo Account from PC

Like we did in the above method, we have to do all the same things again in order to delete Oovoo account from the computer. Follow the below steps and make Oovoo account terminated permanently.

  • The first step is to remove all your personal information given on the app and make yourself unreachable.
  • Once done sign into your Oovoo account by putting your email Id and password.
  • After that, go to  My profile and edit my profile. 
  • Here you will need to make some edits like remove your display picture and type Closed in the display name field. See the screenshot.
  • Once done, again go to settings and then privacy. 
  • In the privacy section, change the search profile setting and make it to “No one”.
  • Afterwards, move to the email section and Under Notifications, uncheck all the boxes provided. In any kinda confusion, you can take the reference of the screenshot given below.
  • And at last, uninstall the Oovoo app from your computer. And your account would be terminated.

If you don't know the un-installation procedure, then see it below.

For Windows XP: Go to the Start menu> then Control Panel>  select Add or Remove Programs> select ooVoo, then click Remove.

For Vista: Go to the Start menu> then Control Panel> select Programs and Features> Select ooVoo> and click Uninstall.

This was the complete step by step guide to delete Oovoo from the mobile as well as from the computer. After following all the steps, your account would be deleted forever.

However, there can be various reasons which made you took the decision to delete the account, but if one of the reason is security or bothering like if someone is troubling you then you can block him/her from the Oovoo.

see the below guide if you don't know how to block someone on Oovoo.

  • To block someone on Oovoo, tap on the contact and hold it. As sooner you hold the contact it will highlight red.
  • Now tap on the Block icon the person would be blocked. And will not be able to contact you anymore.
  • If you want him/her to remove from your roster, then tap on Block and Remove.
  • And if you don't want to block that person but want to remove him then tap the Trashcan icon and then Remove.

Once the person is blocked from your account, he/she would no longer be able to see your profile and contact you. But if you have simply removed him/her but not blocked then, he/she can still contact you.

So if you want anyone to not contact you forever, re-add them and then block him.

Note: If you re-add the person, they will not know they were re-added and won't get an invitation either. So without any hesitation, you can block anyone from the account.

This was all about how to delete Oovoo account and how to block anyone on Oovoo. If you found the guide helpful, you can share it on social media.

And do read our previous article by clicking here.

Continue Reading

Tutorials

How To Mail Merge?

Published

on

Mail Merge is an advanced feature of MS Word. Most of us know how to send a personalized email to a person but when it comes to sending the same email to multiple people with a slight difference, won't you get confused??

This is where word mail merge get's the spotlight. The mail merge in the word is a very powerful tool which lets you create a personalized letter and send it to thousands of people all at the same time.

Similarly, you can create the mail merge labels and envelopes with the same tool.

So if you are inattentive of the features offered by mail merge, stay tuned, we have got a detailed guide on everything about mail merge from what is a mail merge to how to use mail merge.

Excited to learn how to mail merge?? Well, what are we waiting for, let's learn how to do a mail merge!

How To Mail Merge:

Many people over the web keep seeking proper knowledge about how to do a mail merge. Mail merge might sound new to many but merging emails via mail merge is extremely easy.

Before going into the in-depth steps on learning how to do mail merge, let's have a quick look at what is mail merge, it's functionality, how to do a mail merge in word and everything in between.

What is mail merge??

Mail merge is a powerful tool and a great time-saver which lets you write and send personalized emails or letters to many people at the same time. It also helps you create labels and envelopes with the different recipient's information on each envelope.

The working of the mail merge is simple. It uses the main document which contains common fields to be sent to the users and a source file which is basically an excel workbook or the list of information about the users including the name of the recipients, their addresses, contacts, etc.

The mail merges tool imports data from the excel sheets or access database and uses them as the recipient's information. This is just an overview of the working of mail merge. In the below guide, I'll walk you through the exact step by step guide on mail merge. Also, the steps on how to mail merge labels.

How to use mail merge:

The below steps will tell you how to use mail merge to send documents to many people all at the same time.

Step 1. First of all, open MS office on your computer. Now type a new letter or document you want to send to multiple people using an existing database of the recipients' information. Or you can also use the existing documents for the same.

Step 2. Now to begin the process, click on the Mailings tab in the toolbar and then select Start Mail Merge option and select Step by Step Mail Merge Wizard from the drop-down menu.

Step 3. The Step by step mail merge wizard will guide you through the 6 main steps involved in the mail merge. All you need to do is to follow all the steps carefully and get the mail merge done.

Although the help panel is enough to tell you how to mail merge exactly, we have mentioned all the steps on our own to avoid any kinda confusion.

The 6 steps you'll encounter in the whole process of mail merge is given below.

1.. The first step is to select the document type whether it is a letter, envelope or other. Once done, click on the Next: Starting document link below. See the below screenshot if you didn't get what I mean.

2. Now select the starting document. If you have a letter written there, select Use the current document or you can also use the ready to use template offered by word. For this, select the second option that is Start from a template. Or choose the third option Start from the existing document if you have a file saved on your computer and open it.

Once done, click Next: Select recipients and go to the third step.

3. To select the recipients, you can use the existing list on your computer or can create a new one. If you already have an excel sheet or access database, navigate through it and click on Open.

The very next moment, Mail Merge Recipients dialog box will appear showing all the contacts with a checkbox next to it.

You can check or uncheck any person to select/deselect accordingly to control which person should be getting the mail.

Once you are done, click on Ok, select Next: Write your letter and move to step 4.

4. In this step, you need to write your letter if you have not done it so far and add an address block, greeting line or some other information. Just place the cursor on your letter where you would like to add information and select the item, select the template, see the preview and click on ok.

You can add more than one items in this step. Once done, move to the 5th step.

5. In this step, you can preview your letter. Use the arrow highlighted in the below screenshot to see how each recipient will receive the letter, you can modify specific letter if you want.

Once you are ok with everything, it's time to go to the final step which is complete the merge.

6. In the final step, you don't need to do anything but print the letters. In the print dialogue, do the appropriate settings and just click on Print and all your letters will be printed.

That's it, doing mail merge is that simple. It is a simple yet very useful feature offered by Microsoft. If used properly, it comes out to be very handy and helps you save lots of your time and efforts while sending similar mail to multi people.

Sending emails manually to many people can be really effort taking. Use mail merge and enjoy the ease of work.

After reading the guide, if you still have any doubt regarding how to mail merge, feel free to put your query in the comment section below.

And if the guide was helpful to you, don't forget to mention that too in the comment section!!

Continue Reading

Snapchat

How to Use New Snapchat Update?

Published

on

Snapchat is one of the best apps for instant messaging. Snapchat, if you know, is the only app of its type who is self-destructive in nature.

This features, however, was enough to distinct this app from the other messaging apps, but the recent update of Snapchat has made this app stand out of the crowd in many ways.

Initially, snaps and short videos could be sent via this app, and text messaging could be done. But the new update has brought down to us the ability to not only audio chat but live video chat!

Not only this, there are so many new features in the new version of Snapchat that you will end up loving this app even more.

The features include the Snapchat add ons like lenses, chat 2.0, replay, video calling, audio calling, face-swapping, celebrate a birthday and many others!

Are you excited to learn how to use a new Snapchat update??

Well, no worries!! We will walk you through the step by the guide on how to work the new Snapchat update. The lenses, video/audio chat, replay and everything the new Snapchat has come along, including how to update the new version on your phone, everything!

I know you can't wait to learn how do you use the new Snapchat and leverage all those amazing features. Let's head over to the guide!

How to Use New Snapchat Update:

Before that, make sure your phone has the latest version of Snapchat. If you don't have the latest Snapchat on your phone, go to the play store or app store, and update your app!  

Let's get started with the most amazing features i.e. video/audio chat. Then we will go through the other features one by one!

I can assure you, after reading out the tutorial, you won't ever have to ask from anyone how do you use the new Snapchat!

#Video/Audio Chat:

Among so many changes Snapchat has brought to us, the most awaited feature is Video and Audio chat.

Although we already have many apps which support audio and video calls this new feature On Snapchat has made this app a close companion to the big instant messaging apps Whatsapp and Facebook messenger.

Making a Video or audio call on Snapchat is extremely easy! Just go to the contact list on your Snapchat app and tap the contact name you want to talk via audio or video call.

Just beneath his/her name, you will see a text box to type the text message and just below that text field; there would be multiple options like phone icon for the audio call and Camera icon for a video call! Just tap any of these two options accordingly and you are done!

Lenses:

After Audio and Video chat, the most adorable and appealing feature offered by Snapchat is the number of lenses. Snapchat uses the face recognition technology to provide you with amazing lenses!

The lenses let you add the special facial animations and effects including those of a puking rainbow, heart eyes, crying face, Dracula face, birthday celebration and what not. Moreover, the app keeps rolling out the new lenses every now and then.

But this feature only works on the newer version of Android. Those with the older Android phone can't use this feature.

Also, the front camera on your phone should be turned on while using Lenses. To use lenses on this app, long tap your face while in selfie mode or while video chatting with someone.

This step will load the lens just below the screen. Tap on any of the lens icons to see the lenses taking effect. You can swipe the lens to the left to see the more lens.

Filters:

You can make your images look more appealing by adding the filters to them. You can add the current date, different colors and effects, local weather and several other features.

But by default, this features comes disabled. You need to enable filters on your snap chat to utilize this feature.

To enable filters, Go to Settings(by tapping the gear icon)> Manage> Additional Services. Now check the option Filters. 

To use Filters on your Image, take a picture and swipe left or right to see the filter previews. Keep doing this until you finalize the option you liked the most!

Face-Swapping

Face-Swapping is another great update we see in the Snapchat new version. You can easily swap your face with another using Snapchat. Swapping can be done even from the Photos already residing in the gallery of your phone!

Stickers, emoji, and text:

New updated of Snapchat has brought us more than 200 stickers, several new emojis and of course the ability to add a caption to the images.

Using the Stickers and emoji is all the same as we normally do. But for the text, you need to enable from the Additional Services menu.

Once you click a picture, you will see a T icon on the top of the window to add the text.

Snapchat Chat 2.0

The new Snapshot has brought us great features for the chats. Which includes more than 200 stickers, audio, and video notes up to 10 seconds, sending multiple photos at a time, video and audio chats along with the ability to send snaps while online.

Want more features?? I don't think so!

Story replies and Replay Purchases:

Along with the above features, the new Snapchat version gives you the ability to Story replies and the replay Purchases.

You get one free option of a replay once in 24 hours, but you can buy the replay if you want.

The new Whatsapp version gives you the ability to buy the Snapchat replay via the in-app purchases.

On every 3 replays, you need to pay $0.99. Pretty reasonable, isn't it?

So that's how to use a new Snapchat update!

The new update has surely brought us the amazing features which none of us would prefer to miss! So try these features out and let us know your feedback about your favorite features.

We have told you enough that you can easily use the new update of Snapchat without looking for any further instructions.

If you still have any query on how to work Snapchat update, feel free to drop us a comment. For more such articles on Snapchat, do click on this link!

Continue Reading

Tutorials

How To Download YouTube Videos More Faster Using IDM

Published

on

internet download manager

As we all know YouTube is the largest video sharing website. It’s the biggest online video community in the world. It allows Users to Upload their Video, Download YouTube Videos, and these videos can be seen anywhere.

Any user can watch, videos by just login on the website. You can find different variety of videos here, for example, learning videos, entertainment, comedy, action, movies, music, marketing and many more from any part of the World.
According to YouTube Latest Stats more than 3.5 to 4 billion videos viewed per day(approx) and 48 hours of video Uploaded per minute. This is all about the Giant Videos WebSite “YouTube”.

By default, YouTube does not allow to download videos due to Copyrighted/patent issue. It only allows to send the Link to friend & family and he/she can watch it from anywhere in the World on YouTube.

But, today We come up with a new trick to download YouTube videos with More fastest speed by IDM. IDM here refers to fastest- “Internet Download manager”. So, here are the Instructions to Download videos from YouTube using IDM.

Steps To Download YouTube Videos using IDM

1. Go to IDM Link for download Internet Download Manager and download the files. (It's free)
2. After downloading the file, install it in your Computer.
3. After Installing IDM just Restart the computer, Your Browser to run IDM Addon on it.
4. Now go to YouTube Website and while watching it you will get Notify about a button Above Right side your Video Saying that Download this Video-Green Arrow- Just click it and your video will start downloading using IDM with more fastest Speed as compared to others software and tricks.

Benefits of Downloading YouTube Videos Using IDM

how-to-use-IDM-for-youtube

1. It maximizes your Downloading Speed up to 8 times.
2. It Supports Resume/pause Download that will start downloading data from the interrupted state due to the lost connection or Any Network Problems or Computer Restarts due to unexpected recovery problem.
3. It Supports all browsers with User-friendly Interface.
4. It also has many inbuilt features like a dial for download videos and also shut down the computer, when downloads get completed.
5. It directly fetches the Video with All Available and given formats as possible.

So using this awesome and world's best downloading software you can download youtube videos very fast !!

Continue Reading

Tips

How To Use Google Advanced Image Search For Finding Royalty FREE Images

Published

on

Let us start with a simple question, what's the most common way that you use to find images? Most of the people just Google about the topic, save the images that they like and use them for their purpose.

Many people even put their own watermarks on the images they found on Google, well all these things are actually wrong you may have to pay a fine of almost 1000$ per image.

You never know that the image you downloaded from Google is copyrighted or not. Personally speaking, many of my fellow blogger friends have already faced an issue because of using copyrighted images.

Sometimes you may even have to shut your blog down.

You must be thinking that the best way is to generate the images yourself. Well, this is not the only solution, no doubt this is one of the best ways. I

n this article, I will be showing you How To Use Google Advanced Image Search For Finding Royalty FREE Images.

You must be wondering what do I exactly mean by Royalty free images, these are some images which are not acclaimed/copyrighted by any online firm or blog.

It means you guys can use these images in any way you want, no one will charge you even if you put on your own watermark on these images.

These images also prove to be pretty handy to the people who design flyers/posters for different firms and educational agencies.

So without any further delay lets get down to the main topic, below are given the steps using which you will easily be able to find some useful and royalty free images.

Follow the steps as listed below:-

  1. Google whichever topic that you want to search the image on and select the images tab.
  2. Now all the right you will see a gear icon, all you need to do is just click on that gear icon and go to advanced search.
  3. Now once you click on Advanced search, it will open up a completely new window in the same tab, here you will see a lot many setting, all you need to do is just simply scroll down to Usage Rights once you click on that it will open up a drop-down menu, from this drop-down menu select “Free to use and share even commercially “.
  4. Now once you have done this, without playing around with the other options, just go ahead and click on advanced search button which will be on the right side in blue colour.
  5. Once you click on the button it will take you back to the image window in the same tab, but this time all the images you see up there are completely royalty free and meant to be used in any way that you want to.
  6. So all good to go? you will now also get some additional features, for eg:- when you click on Labeled for reuse you will get several options and you select the one you feel the most suitable to you.

Hope this article helped you out, Keep stalking for more tricks 🙂

Continue Reading

Trending