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 and WordPress builders from blogs like Havas Digital Server. 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 *

OS

How to use BitLocker to Encrypt your Files

Published

on

How-to-use-BitLocker-to-Encrypt-your-Files

Locker means a safe place where you can put your personal or important things hiding from others. We all have some things which we don’t want to share with others same as in the computer you have any important data that you want to hide from the outside world. For that, there are many software available over the web and as well as well-known by you so no need to describe it.

But if you want to lock your Hard Drive partitions without any software then? In that case, Microsoft has provided one wonderful tool known as “BitLocker” in Windows Vista, 7 and 8 for encrypting your entire Hard Drive partitions. Using BitLocker you can lock any volume on the computer even the one you boot from. But a question arises in your mind that How to use it, right? So, I will show you two different modes to use BitLocker on your computer. If you wanted to Defrag the Hard Drive, you should see that.

1. “How to use BitLocker on a normal/data volume”

2. “How to use BitLocker on Boot volume”

Let’s see the first mode:

1. How to use BitLocker on a normal/data volume?

A simple way to enable BitLocker – right click on any volume and select “Turn BitLocker on” to start the locking process. After clicking a window will pop-up (as shown in the figure below) asking to enter a password to use with the drive – you will also ask to say a copy of the recovery key somewhere at safe place and then it will begin encrypting your drive.

How-to-use-BitLocker-to-Encrypt-your-Files

By this method you can lock all the drives on your computer except “C:/ drive” or “Boot partition”.

Now, the second mode:

2. How to use BitLocker on Boot volume

Yes, it is true that you can encrypt the main operating system drive, but this has some special requirements since the drive has to be unlocked before boot. First of all this requires that Windows has a seperate boot partition that isn’t encrypted; in case if you don’t have then create a separate boot partition. The second requirement is that your system include a TPM (Trusted Platform Module).

If you try to encrypt your boot volume without satisfying the above to requirement then it will give an error as shown in the figure below.

How-to-use-BitLocker-to-Encrypt-your-Files

So, in that case you will need to configure your system to use BitLocker with a TPM. Here is how you can do that.

  • Press [win + r] and type “gpedit.msc” in it and press enter to launch the Local Group Policy Editor

How-to-use-BitLocker-to-Encrypt-your-Files

  • Now, browse to – “Computer Configuration > Administrator Templates > Windows Components > BitLocker Frive Encryption > Operating System Drives
  • In the right panel. double click the setting “Require additional authentication at startup” and select “Enabled”
  • In that please check the below options that “Allow BitLocker without a compatible TPM…” is checked.

How-to-use-BitLocker-to-Encrypt-your-Files

  • Then, Click Ok – you are done.

Now you will able to start the BitLocker process on your system drive, and will have the option to either enter a password on startup or insert a USB drive to boot.

If you have any problem regarding “BitLocker” then put your comments below so that I can surely help you to get rid out of your problem. Hope this guide helped you to understand how to use BitLocker.

PC taking more startup time? Change the Startup program to boost the startup process in windows 7.

Continue Reading

Tutorials

How To Create QR Codes In Easy Steps

Published

on

In this technology-infused era, everyone wants to have an edge over others. For this, expeditiousness and use of trending technology is a must. Gone are those days when we used to stick to a particular technology for a long period of time.

With the serial advancement, first came the technology of Bar Codes which was derived from the concept of storing some sort of quick information or data in a flat piece. Then came the successor of Bar Codes, QR code (a two-dimensional Bar Code) with some great features.

QR codes facilitated us with the facility of storing data that is very often used such as name, address, contact details, certain URL’s, social media profiles and much more, all confined in a square grid comprising of certain standardized patterns.

See Also: How to Find People on Snapchat

QR codes have revolutionized the way that information is being transfered.
So, let’s dig a little deeper and find out what are QR codes and How to create QR codes in easy steps.

What is a QR code?

Quick Response codes, often abbreviated as QR codes are a kind of matrix Bar Code or two-dimensional Bar Codes (a machine-readable code represented in the form of patterns of parallel lines and numbers usually used to store information’s like price, index of an object to which it is attached ).

How-To-Create-QR-Codes-In-Easy-Steps

QR codes came to us all the way from the technological hub Japan where they were first designed for the automotive Industry.
A QR code uses four industry standard encoding modes to efficiently store information about the item to which it is attached and those are:  Numeric, Alphanumeric, Byte/Binary and Kanji (漢字 logographic Chinese character).
A QR code consists of Square dots (black modules) systematically arranged in a square box with a white background and can be read by imaging devices like scanner or camera.
Fact: the QR code system was invented in 1994 by Denso wave (a subsidiary of Toyota) with the sole purpose of tracking vehicles during manufacture. QR codes can store more than 4,000 alphanumeric characters in a limited space.

What purpose are QR codes used for?

QR codes are quite popular in the industry because of its quick readability and larger storage capacity as compared to the usual Bar Codes.
#1: QR codes can be used to link directly to a URL
#2: QR codes can be used to store data like name, address, numeric values like price, phone numbers etc.
Examples:
#1: One can add QR codes to his/her business cards that could store name, address, contact numbers, links to the social media presence.
#2:  QR codes are quite often used in product packaging.
#3: QR codes can be used in print advertisements to boost reach and earnings.

How to create QR codes in easy steps?

See Also: How to Make Emoticons for Facebook?

If you will follow these steps carefully then you will get to know how to create QR codes easily.

Step #1: Search for an online QR code generator. If you will Google it by the keyword “QR code generator”, you will find a plethora of them. Some of them are QRstuff and the QRcode generator. For the sake of instance and simplicity, we will be using QRstuff at first.

How-To-Create-QR-Codes-In-Easy-Steps

Step #2: Select the Data Type (basically the type of information you wanted to convey through the QR code) of the QR code. You can choose from various options like: Website URL, YouTube Video, contact details etc.

Step #3: Type in the details corresponding to the data type which you have chosen.

Step #4: Select the type of color of the QR code. You can select your desired color from the user-friendly multi-color swatch.

QRstuff also facilitates the user to have a preview of the QR code which has been created.

Step #4: Download the QR code. It equips you with the PNG file of the QR code. Moreover, one can even print and E-mail the QR code directly from the website itself.

QR codes created by these methods will work perfectly fine but going with the paid platforms obviously has its perks, here we list some of those perks:
1: you can edit the content without playing with the design of the QR code.
2: you can have multi-user accessibility for managing QR code campaigns.
3: you will be equipped with the facility of tracking the number of scans corresponding to the geography, device and time.
4: you can have the desired resolution, scalar or vector image, format, and quality.

Here are few paid online websites: QR-CODE-GENERATOR  and Kaywa

Alternatively, one can also use software for creating QR codes easily.

QR codes work like a charm, You have to see it to believe it. Hope we are efficient enough to make you aware of the basics you need to know while creating you first QR code.
If you have any query regarding QR codes, do let us know via comments. We’ll surely get back to you and will try our level best to solve your thing.
If this piece added some worthwhile value to your knowledge base, then don’t forget to show your appreciation. Do share it on your social media profiles. Thank you for the same in advance.

Continue Reading

Linux

How to Use uTorrent to Download Files

Published

on

Willing to get uTorrent movies download files from the internet just at one go? Well, it is the time for you to go and use the uTorrent application. With lots of multiple features for you to use, you can easily download different files from this application just with a click.

All you have to do is learn how to use it and then download the application for further usage. Well, if you do not know the correct process to do it, here is a quick guide for you to go for is you are unaware of How to use uTorrent to download files.

See Also: How to Use BitTorrent Effectively

#1 How to Use uTorrent – Installing The Application

How-to-use-uTorrent

 

Step 1 The first and foremost thing that you need to do is to install and the downloading process. For Windows PC users, it is recommended that you can download the file from the uTorrent website and then get on with it. However for Android users, you can have a download from the Google Play Store.

Step 2. After you have finished on downloading the file, you now have to continue running the installer. You have to make sure that you are paying attention to every part of installing the file. This is because it will give you the right thing to go for.

Step 3. The next step is of configuring the files and folders with the application. Once you run the software, you now have to configure where to save the files and where not to. This will help you to select the preferences and then customizing the download when you know how to download uTorrent.

Step 4 The next step that you have to cover is to set the bandwidth limits. Once you have covered the previous step, it is now about connecting the ISP with the application. You can do this from the options menu of the application mentioned.

Step 5. The next part will be to enable the protocol encryption. This is the key element to increasing the download speed of your files by hiding the ISP traffic from the application set in the options. You have to select the option of enabling encryption from the mentioned part in the application.

Step 6. Now you have to open the ports of your firewall. You can do this either by going to the default browser which you are using or by giving a click to the option in the application itself. This will help you to run multiple downloads with a high-speed connectivity from the start.

See Also: How to Stream Torrents on iPhone?

#2 Downloading a Torrent File

How-to-use-uTorrent

Step 1. The first thing that you need to do is to find out a torrent file online. However, you can do it easily with the help of different torrent engines which are available online. Selecting the torrent file includes everything from games to software and uTorrent download movies and many more.

Step 2. Examination of the appropriate file to download the torrent should be one of the key things you have to perform. There are terms such as “seeders” and “leechers” which you need to check as well. The more they are means the recent they have been uploaded and as a matter of fact, the better they will help you to download.

Step 3. Viruses are a common thing to catch online and what you have to do is to wait for the comments in the file before you download it. You can choose a file according to the comments mentioned below which will help you to guess which file is safe and which one is not.

Step 4. Once you have now found out the uTorrent download movies for free, you now have to click the download button attached to it. It will help you to download the Torrent file. However, you have to wait for a few seconds to download the file.

Step 5. Next you have to give a double click to the downloaded file to launch it in the uTorrent application. You now have to verify the downloading place and the click on to star download option which is present inside the application.

Step 6. Last but not the least is to check the internet connection. You need to use the internet at the maximum speed for a faster download. This will get the download started in a flash and will end up in downloading the file as quickly as possible.

#3 Monitoring The Download

How-to-use-uTorrent

Step 1. The first thing that you need to do is to check the internet connection. Remember the better is it from your Internet Service provider, the faster the download will happen. If you have a slow connection, do not use the internet for any other purposes at the same time to receive the maximum out of your files.

Step 2. It is now time to check the peers and the connectivity speed. Though the connectivity speed will depend on the time of the sharing of the file, the peers are related to the speed of the internet connection. Thus, you need to be sure in this field of connectivity.

Step 3. Once the download has finished, you can now open it and install the recommended software you were trying to download. However, you have now downloaded the full content which is actually of a much bigger size indeed.

Step 4. Once the download has been finished, you can see an ongoing process of seeding. This seeding actually helps you to upload the recent file of the application and go for it. All you have to do is continue seeding until it finally stops as the other users will get a new file and use the files.

Step 5. The last step of all if you do not want your content to be tracked by other people, you have to install PeerBlock. This helps in keeping your contents safe and does not disclose your IP from getting followed by other members or law enforcement agencies.

See Also: How to Download Free Movies for Android Easily?

Final Words

This is a complete guide for you on How to use uTorrent to download files. You can now download files from anywhere and just get the job done Even if your device turns off, the download does not go away, it continues from where the file has been left off.

Continue Reading

Tutorials

How to Connect Your TV to Your Computer

Published

on

connect-tv-to-your-computer

One way to show digital pictures and video to friends and family is for all to circle around the home computer screen. Alternatively, you can connect your tv to your computer and send the images to the TV. Technology also exists to network a TV and a computer in the other direction, so that you can watch television programs on your laptop or PC.

Showcasing digital images on the television

With a digital camera or video recorder, user can create multimedia image files stored on their PCs. Showing these images to others can be inconvenient, however, especially if your computer screen is small and located in a private room of the house. Displaying them on television usually allows you to show them at a larger size and in a more comfortable location.

You can connect a computer to a TV either wirelessly or with cables. The method you choose depends on the types of connections your TV supports as well as your budget for purchasing additional hardware.

See Also: How to Watch TV Online?

Viewing television on the PC

You may also be interested in watching television programs on a computer. This is also possible with the right wired or wireless equipment installed. Some TV broadcasts are accessible directly via the Internet and no connection to television is required. Those who own Digital Video Recorders (DVR) may also prefer to connect their computer to the DVR rather than the television directly.

Connecting Computers to TVs through Wires

Televisions do not normally support Ethernet cable connections. Instead, you will typically connect your laptop or desktop PC to a TV using one of the following types of audio-visual (AV) cables:

· SO-Video

· HDMI

· DVI or HDMI-to-DVI

· VGA

· Any of the above – to-SCART (in Europe)

A scan converter converts the computer’s video signal into standard TV formats. You may need to set up a scan converter to connect your computer and TV if, between them, the two do not support any compatible combination of AV cable technologies listed above. Latest televisions, however, generally support multiple types of digital inputs and finding the right cable should not be too difficult.

 connect-your-tv-to-your-computer

•Connecting Computers to TVs Wirelessly

In place of using cables, you can also use Wi-Fi to connect computers and TVs wirelessly. Since televisions do not ordinarily support Wi-Fi, you will need to install a separate unit between the computer and TV. One common solution is called a Wireless PC to TV system or [i[Digital Media Receiver. These products connect via AV cable to the TV and supply Wi-Fi connections to any computer in the home.

See Also: How To Get Netflix On TV

Another wireless PC to TV connectivity option is based on Windows Media Center Edition (MCE). If you purchase a Windows XP or Windows Vista PC with the MCE application included, this system contains built-in wireless connectivity support for streaming images to your television. A few of these systems also support TV tuner cards that allow your computer to receive incoming television signals. Finally, you can extend the capability of a Media Center PC across an entire wireless home network by installing a Media Center Extender product like the Linksys DMA2100.

Happy computing!! and now you are able to connect your tv to your computer

Continue Reading

Tech

How To Play PS3 Games On PS4

Published

on

By

How-to-play-ps3-games-on-ps4

The Sony Playstation gaming console was launched in the year 1994 and has held gamers enthralled with games ranging from Super Mario Kart to Devil May Cry and BloodBourne.

However, with the ever-increasing complexity of the console from version to version, some games from previous generations are now unplayable. That is up until now. We decided to put together a guide on how to play PS3 Games on PS4 in tribute to the next generation of cloud-based gaming.

Sony PlayStation 4 is one of the premium gaming consoles rivaled only by Xbox One and Nintendo Wii. Being at the pinnacle of the gaming industry for more than two decades now, the PS continues its market dominance much to the delight of Sony PlayStation fans everywhere!

If you wanted to Play Xbox 360 on PC, here is How to Play Xbox 360 Games on PC?

How to Play PS3 Games on PS4

How-to-play-ps3-games-on-ps4

Can u play PS3 games on PS4?” was the question asked by one of our readers. With the release of Sony Playstation 4 and PS4 not supporting the discs meant for the PS3, this question posed a possible pockmark on the PS4’s otherwise incredible gameplay and performance. So, can you play PS3 games on PS4?

The answer at the time was sadly – No. All the PS3 games stayed with the console for which they were meant. Any disc you bought for the PS3 stays with it, and you will have to get new game discs for PS4.

But, can the PS4 play PS3 games? The answer is yes. Although they both have extremely different internal architectures, PS4 does have the computing power to virtually emulate the PS3 architecture, which makes us think – Why would Sony do this to us?

Give us the computing power, but not the games we all love and adore. Can PS4 play PS3 games? If yes, how?

For those hoping to play PS3 games on PS4, Sony has released Playstation Now, a cloud-based gaming platform that allows you to play all your PS3 games on your PS4 by streaming it to your PS4.

For the gaming community, the PS Now comes as a boon that they had been long awaiting. This allows you to stream games from the cloud and play them in sync with your Sony Entertainment Account savegames. So, say hello to an all-new experience from all your old favorite games from last gen.

How-to-play-ps3-games-on-ps4

Playing the classic vintage games on a new console can be a thrilling experience. The Advanced Graphics rendering and the amazing world texture enhancements make it look more real than the originals did, making the games seem new to the eye. Gameplay remains the same since the control scheme is no different than any previous model of PS.

An interesting thing to note about the PS Now is that it must always be connected, which does provide for some insecurity to those without a stable internet connection. But since all things are based on the cloud for the PS Now, this is a sad thing.

The upside of this is that your savegames will never be corrupted and you can always continue gameplay from the point where you last logged off.

Ever played Fantasy Football? Here is How to Play Fantasy Football?

This somewhat combines the concepts of MMO gaming and traditional gaming with cloud synced savegames for some games like the Batman Arkham Series or Assassins Creed, where you either start where you last left off (out of mission) or in a nearby zone to the place where you can continue the free roam that sandbox games like these give you.

P.S. Now has been in development for some time (since 2014 in fact) and recently released in May of 2015 in North America. Over 400 games are accessible in the cloud for either a monthly subscription of $19.99 or a three-month subscription fee of $49.99.

How-to-play-ps3-games-on-ps4

Does PS4 play PS3 games as well as the original console? The answer is ‘No’ again – Not all games can be emulated and even when they can, it requires a minimum of 5mbps uninterrupted internet speed to preload the game from the cloud. Right now, only 400 of the thousands of games available for the PS3 are available for the PS4, but thankfully almost all our favorite top-sellers are included.

Still, it is a blessing for those praying to the gamer gods for better clearer graphics and amazing gameplay for the games that do run.

Among these are the Assassins Creed Games up till ACIII, Batman Arkham Series (not including Arkham Knight), BlazBlue, Darkstalkers, God of War, Hitman HD remakes, Infamous, Resident Evil, Injustice: Gods among us, King of Fighters ’93 and XIII and several Lego video games including Batman and Harry Potter.

All these are highly recommended if you haven’t played them on the PS3 as well. But any gamer worth his joystick would have played most of these, if not all of them.

PS Now has a 7-day free trial as well, so you can test out how your internet connection responds to the bandwidth load from the cloud games.

Are you a Pokemon fan? You are going to love the Pokemon game on the iPhone. Here is How To Get Pokemon on iPhone

If it does work out, you can then choose to rent games for the standard 4 hours, 1 day, 7 days, 30days and 90 days. Or you can pay the subscription. Either way, it’s awesome, and if you have a PS4 and a decent internet connection – go head and sign up now to get access to all the goodies that Sony PlayStation Now has.

Warning: Side effects may include being unable to get up from your seat, sore thumbs, clawed hands, unblinking eyes and angry moms. If you have suffered from these before (especially the last one), consider keeping maximum snacks and caffeinated fizzy drinks to fight the adverse effects (and do it when she’s away)

We hope this answers the question – how to play PS3 games on PS4 and the question can I play PS3 games on PS4. The PS4 might not be meant for this exclusively, but it sure does meet the requirements of those nostalgic gamers out there with a thirst for adventure, action and adrenalin that only the classics can provide.

Continue Reading

Trending