How to Create a Graph in Excel

Microsoft Office is one of the most popular applications around the world. Microsoft Excel is a part of this package. Most of the people prefer to use Excel for official purposes due to three main reasons. These reasons are Storing, analyzing and displaying of data in a convenient form. You can present the stored information in the form of different graphs in Excel. There is also a chart wizard in Excel spread sheets which helps to create charts in a very easy way.

In this tutorial we will guide you to learn how to create a graph in Excel in few simple steps.


Step # 1 – Create a Data Table

In the first step, open Microsoft Excel Sheet and create a data table. You can either enter the information by your assumptions or choose actual data records of any business. Now we will use the information available in this table and transform it in the form of a graph.

Make an information table

Step # 2 – Open Chart Menu

Click on the “Insert” tab which is located at the top left corner of the window. Select the “All Chart Types” option from the chart’s menu to open the list of graph and chart designs.

Go to the chart options

Step # 3 – Select Chart Style

A chart window will open in front of your screen in which you can see various types of charts and graph available in different categories. Choose a “Line chart” style from the menu and click on the “OK” button to proceed.

Choose a graph

Step # 4 – Select Data

Now a blank chart will appear on the worksheet. Right click on the chart to open its menu and click on the “Select Data” option.

Open chart settings

Step # 5 – Fetch Data into the Chart

A new window will open which allows you to insert the information into the chart. Now click on the first cell of the table and drag a selection mark towards the last cell. Once it’s selected, information in the table will automatically appear in the Data Source window. You can further switch rows and columns or edit the information according to your requirements.

Getting data from the table

Step # 6 – Add or Remove Information

You can insert or delete additional information in your chart by clicking on the “Add” or “Remove” buttons. The “Hidden and Empty Cells” button allows you to hide the empty spaces or blank cells in your chart. Once you’re done, click on the “OK” button to continue.

Adjust the information

Step # 7 – Choose a Design

After inserting the information in your chart, move over to the “Design” tab. This option allows you to apply predefined layouts or themes to your chart. Click on the desired colored theme and chart layouts from the menu to apply them.

Select colors for the chart

Step # 8 – Select a Layout

After applying the theme, click on the “Layout” tab which is located next to the “Design” tab. The “Layout” option allows you to adjust the Chart’s Main Title, Axes Titles, Legends Placing, Data Labels and Table Options. Choose these options according to your preference and move over to the next step.

Choose a chart’s layout design

Step # 9 – Appearance and Formatting

The “Format” tab allows you to change the format of your chart. The format option consists of the Fonts style, its size, spacing, alignment and other settings.

Adjust its appearance