How to Make a Bar Chart

A Bar chart is horizontal while a column chart is vertical. Please see steps below to make a Bar chart, or check here to see how to make a column chart:

Step 1: Select the data with category names;

This image has an empty alt attribute; its file name is excelstackedchart011.jpg

Step 2: Click "Insert" Tab from the ribbon;

This image has an empty alt attribute; its file name is excelinserttab.jpg

Step 3: Click the "Clustered Bar Chart" in the Chart area;

Step 4: A Bar Chart will be created.

Step 4: Change Chart Title: click on the title then type the proper title;

Step 5: Add Data Labels: Right click any portion of the bar, in the dialog box, select "Add Data Labels" from list, then select "Add Data Labels" or "Add Data Callouts".

Notes: Excel 2010 and earlier versions have no option of "Data Callouts".

Step 6: Format Axis: Double click on the Axis, in the Format Axis window, change the values to make chart changes.

Download Example

Leave a Reply