Create Charts in Excel

Home/Excel/Create Charts in Excel

Well! we have seen some basics of charts in the previous topic. Now, we will see how to create charts in Excel. In this session I will take your through the step by step to create basic charts in Excel. Then we will see the advanced charts options to customize charts in Excel.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Getting Started with Charts in Excel and Create Charts in Excel. Start Learning And Create Awesome Charts in Excel.

Getting Started with Charts in Excel

We will understand what are the basic things required for creating Charts in Excel. and then we will see the Step by Step approach for Creating Charts in Excel.

Prepare: Understanding Basics for Creating Charts in Excel

Let us see what are the basic things we need for creating a basic chart: We have to consider the following things before creating Charts in Excel.

  1. Data: We need some data to plot the Charts in Excel.
  2. Select the Data: We need to decide and which portion of the data you want to plot on the graphs
  3. Clean the Data: Our data should be cleaned before plotting the data
  4. Select a Chart: Think which type of Charts suitable to represent our data
Steps: Steps for Creating Charts in Excel

Now we will see what are the basic steps we need to follow for creating Charts in Excel: Steps for creating charts are more or less same in all version of the Excel (Excel 2003,2007,2010 and 2013). We need to follow the following steps to create Charts in Excel.

  1. Select the Data Range: First we need to select the data range in Excel Worksheet
  2. Select Chart Type Go to Insert Menu and Select the required Chart Type from Charts Ribbon Tabs
  3. Size and Position: Now you can able to see the Chart created for selected data. You can select the charts and place and re-size the chart as per your requirement
Practice: Practical Learning – Creating Chart in Excel

As mentioned in the above we need some data to plot the Charts. Here is the sample data which we I am going to use for explaining this topic. There are three fields: Items, Quantity and Cost.

Step 1: Select the Data Range
In this example, I want to show you the graph for Quantity of Items. So, we need to select Items and Quantity for Charting. You can the following screen-shot how I have selected the required data for charting.

Step 2: Select Chart Type
Now we have to select the Chart Type. As this data is categorical, we can select Column Chart Type from the Charts Ribbon Menu Tab. You can see following screen-shot how how I have selected the Chart Type from the Ribbon in Excel.

1. Go to Insert menu in The Ribbon
2. Select the Column Chart from The Charts Ribbon Tab

Step 3: Size and Position
Now our chart is ready, we can re-size and position wherever you want in the Worksheet.

1. Mouse hover near Chart Border/Edge (Not Chart border /Edge), your mouse icon will turn to a Plus type (selection Icon). Then hold the mouse and Drag it to the place which you want
2. Mouse hover on Chart Border/Edge, your mouse icon will turn to a two side arrow icon (re-size Icon). Then hold the mouse re-size the chart as per your requirement.

Creating Basic Charts in Excel

We have already see how to create basic charts in Excel. Now we will see the creating frequently used charts in Excel.

Creating Basic Column Chart in Excel

As discussed above, Column chart is suites to present the categorical data. We can quickly have look at the graph and understand the data. It is also good for comparing two groups and determine the groups.

Here is the example chart to show you how to compare two groups of data in Excel Charts.

By looking at the graph, we can quickly understand that the purchasing cost is more in 2013 in all the categories than 2012.

Creating Basic Bar Chart in Excel

Bar chart is useful to study different categories and their ranks. You can use for representing the ranking data or customer satisfactions score for the different products or any item.

Following is the example data and Bar Chart to show how we can use Bar Charts in Excel. Generally we sort the data before plotting on bar chart if the we study categorical data. If it is rating scale we should not sort the data.

In the above examples, we can see the rating scale is remained same and the other charts with categories is sorted based on the reposes. By looking at these graphs we can quickly undertand the data and derive meaningful insights.

Creating Basic Pie Chart in Excel

Pie charts is the another useful charts in Excel, we generally use how the different categories are distributed in population.

We can easily conclude the data by looking at the Pie charts how different groups or categories are sharing total value. Based on the above charts we can understand most of the customers are liking the products.

Advanced Charts Options to customize Charts in Excel

You can see more charts options in our advanced tutorials covered in the following topics:

By |September 22nd, 2013|Excel|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment

Related pages

vba sheet protectionvbscript examples programsvba case statementvba sheet1use of excel formulas with examplevlookup excel samplefree excel dashboard widgetshow to insert row in excelhow to write vba code in excel 2010excel vba copy worksheetlookup in ms excelleft excel vbashortcut keys excelexcel months between two datesvba select casedaily scrum meeting templatesql interview question pdfvba user inputvba skillsmacro to delete columnshow to insert checkbox in excel 2007sample tosdynamic array excelwhat is trim functionhow to eliminate rows in exceladodb tutorialabsolute reference excel shortcutleft vbaexcel macro for dummiesremove duplicates in excel 2003isna excel functionmerge 2 columns in excelif iserror in excelrecordset vba excelexcel 2007 pivot chartsql syntaxesvba adodb.connectionloop formula in excelunprotect sheetvb questions and answersswot analysis ppt templateautofit row heighthow to use sumif formula in excelmainframe sas tutorialvba deletevba vbyesnoadd the developer tab to the ribbonexcel 2007 dashboard examplesexcel lookup valuehow to merge excel columnsestimation template for software developmentexcel vba connect to sql serverexcel hyperlink functionsorting in sqlvba conditionexcel userform listboxword 2010 show developer tabformula sumifif statements excelhow to make tick boxes in excelvb nested ifvba redim arrayvba application screenupdating falseexcel vba goto celllearn vba from scratchhow do you unprotect an excel spreadsheetexcel 2010 multiple if statementsmacros in excel exampleshlookup in excel 2010excel vba sortdml commands in sql with examples pdfunprotect excel with passwordauto save excel 2010project management spreadsheet excelexcel vba message box yes novlookup and functionexcel vba filenamehow to lock an excel sheet with passwordvba excel commentexcel command to insert row