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.
- 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 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:
- Run MS Excel.
- 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.
- 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.
- Go to the Insert Tab > Find the Chart Section > Choose Column (I've used the first one).
- Now you will see a Column Chart in your book.
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.
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.