For example, if you want to display only the. Select the type of command you want to add from the Choose Commands From drop-down list. Use the Excel Options dialog box to add any Excel 2010 command to the Quick Access toolbar. In this tutorial, we have entered 'Product Life (in Days)' as the title for the bar chart. On the right, Excel shows all the buttons currently on the Quick Access toolbar in the order they appear on the toolbar.

Enter the text that you would like to see as the title. Click on the title and it will become editable.

Now you should see a title appear at the top of the chart area. Click on the Chart Title button in the Labels group and then select 'Above Chart' from the drop down menu. To add a title, select the Layout tab under Chart Tools in the toolbar at the top of the screen ( Chart Tools will only appear when you have the chart selected). By default, your chart will be created without a title in Excel 2010. You can see the axis values on the bottom of the graph for these horizontal bars.įinally, let's add a title for the bar chart. The shelf life (in days) is displayed as red horizontal bars and the restock time (in days) is displayed as blue horizontal bars. Now you will see the bar chart appear in your spreadsheet with horizontal bars to represent both the shelf life and restock time for each product. In this example, we have selected the first bar chart (called Clustered Bar) in the 2-D Column section. Click on the Bar button in the Charts group and then select a chart from the drop down menu. Select the Insert tab in the toolbar at the top of the screen. In this example, we have selected the range A1:C5. Highlight the data that you would like to use for the bar chart.

To create a bar chart in Excel 2010, you will need to do the following steps: Click the Move Up or Move Down arrow to position the separator where needed.

In the list of commands on the left, select and click Add.

In the Choose commands from drop-down list on the left, pick Popular Commands. If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Create a Bar Chart Open the Customize the Quick Access Toolbar dialog window.

Add toolbar to excel 2010