create a bar graph in excel 2011 for mac

You can further switch rows and columns or edit the information according to your requirements. Once it’s selected, information in the table will automatically appear in the Data Source window. Now click on the first cell of the table and drag a selection mark towards the last cell. Right click on the chart to open its menu and click on the “Select Data” option.Ī new window will open which allows you to insert the information into the chart. Now a blank chart will appear on the worksheet. Choose a “Line chart” style from the menu and click on the “OK” button to proceed. Select the “All Chart Types” option from the chart’s menu to open the list of graph and chart designs.Ī chart window will open in front of your screen in which you can see various types of charts and graph available in different categories. Now we will use the information available in this table and transform it in the form of a graph.Ĭlick on the “Insert” tab which is located at the top left corner of the window. You can either enter the information by your assumptions or choose actual data records of any business. In the first step, open Microsoft Excel Sheet and create a data table. In this tutorial we will guide you to learn how to create a graph in Excel in few simple steps.

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

Microsoft Excel is a part of this package. Microsoft Office is one of the most popular applications around the world.

Create a bar graph in excel 2011 for mac