Skip to main content

Creating Column, Bar & Pie Chart in MS Excel (With Sheet)


Creating Column, Bar and Pie Charts in MS Excel


Hello Dudes! Hopefully you're alright and also hope you're enjoying my posts. After a long time, I've come with MS Excel Tips. Couple of Months ago, I shared an Excel Sheet with you that includes - Salary Sheet, Result Sheet, Electric Bill etc. Today I've come with another sheet which will help you to learn how to create Column, Bar and Pie Chart in MS Excel. 


Actually I was planning to share this tips with you for a long time. But I couldn't understand how to start and what to write. Finally, I've decided to share a sheet with you as example. And I will also try to clarify how to create charts in MS Excel. 


Applies to:
  • Office 2007
  • Office 2010
  • Office 2013
But I've used Office 2010. So there might be some changes in other versions. 




For your convenience, you can download the above file and have a look before we start. It's just 22 KB! Remember, it is an .xlsx file and can only be opened with Office 2007 or above. Three charts are in three sheets. You will get the names at the bottom of the worksheet. 

Okay let's begin. I am using Office 2010. 


Column Chart:


Column Chart is a widely used chart which is normally used to show Profit, Growth Rate etc. It is shown as vertical lines. In my example sheet, I showed the pageviews of my site for last five months. To create a column chart, follow the steps below:
  1. Run MS Excel.
  2. Input your data (Maybe you can enter particular in one column and values in other columns). In my example, I showed only a single column value. You can enter multiple columns. Maybe you can show the pageviews of three years while I showed only one year.
  3. Now select your input data (in my example, I selected only data - June to 120000) to avoid the column header to be appeared in the chart. 
  4. Go to the Insert Tab > Find the Chart Section > Choose Column (I've used the first one).
  5. Now you will see a Column Chart in your book. 

Bar Chart:

This is almost similar to Column Chart but gives you a different flavour. It presents data horizontally. Creating a Bar Chart is almost similar to that of Column. After inputting the data, you have to go to the Charts and then choose Bar Chart. 


Pie Chart:

The best example of the use of Pie Chart is the representation of Budget. Without Pie Chart, representation of budget can't be imagined. It is notmally used when something is divided into parts. For example, in a budget, we can see what percentage of money will be spent in a particular sector. 

Such as for Education - 20%, for Defense - 30%, for Industry - 15%, for Power - 20% etc. Only Pie Chart can show this properly. 

To create a Pie Chart (take help of my example sheet), you have to enter the category in one column, and then enter the values in another column. Then select the input data, go to the charts, choose Pie Chart. That's it. 


Customization of Charts:

Creating a chart is not very difficult. But arranging it properly could be a boring task if you don't know how to do it. I'm gonna discuss about customizing the charts in brief:
  • After creating any chart, if you click on it, you will get three new tabs - Design, Layout and Format.
  • From Design Tab, you can change your chart design - Chart Style and Layout. 
  • In Layout Tab, you will find Chart Title, Legend Position, Data Label etc.
  • Format Tab will allow you to perform all kinds of formatting tasks including text color, line color, line style, font style, shape effects etc. 

Of course you can use your mouse to choose a particular part of the chart. Then you can change that part. To select a segment of your chart, click on it and then click again (not double click). If you wanna move any part of your chart, hit on it and move it when you get the moving pointer. 


Stay with Marks PC Solution to get more interesting IT topics!


Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALLCARSGOB

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow

Download Puzzle Flash Game - Save Them

Hey Flash Game Lovers! Today you're getting an amazing puzzle game - Save Them! It's a flash game and the download size is only 382 KB. In this game, you have to move 3 missionaries and 3 cannibals from one side to another through a boat. In any side, if the number of cannibals is more than the number of missionaries, then cannibals will eat the missionaries!  Download Save Them Download the game from the above link. It's a zipped file. Download size is only 382 KB! After downloading the game, you have to unzip it first. Then double click on the SaveThem to start the game.  How to Play? After starting the game, you will get the instruction. You have to make sure that in no side, the number of cannibals is not more than the number of missionaries. This is your only challenge. You have to take them from left side to the right side of the lake through a boat.  Press on a character to jump to the boat. Thus you can take any two of them a