How to Create a Bar Graph in an Excel Spreadsheet

by Jenny Hansen
Photo courtesy of Microsoft

Bar graphs show data from left to right using horizontal bars. The category axis, called the x-axis, is on the left side of the chart. The value axis, called the y-axis, sits at the bottom of a bar chart. Excel 2013 calls these vertical charts Bar Charts, as opposed to the more commonly used Column Charts in which the x-axis is horizontal and the y-axis vertical.

Adding graphs in Excel 2013 is as easy as selecting the data and choosing your preferred chart type from Charts grouping on the Insert tab. By default, charts embed in the active sheet, but chart location is simple to change.

Creating Bar Graphs

Step 1

Select Data to Chart.

Select the data you wish to chart, including the headings. Failure to select headings affects chart categories, data labels and the legend.

Step 2

Bar charts can be 2-D or 3-D.

Click the **Insert** tab and press the drop-down arrow next to **Bar** in the Charts grouping.

Cluster Bars compare groups of data.

Pick the **2-D Bar** or **3-D Bar** option that works for your data. For example, if you're comparing groups of costs against one another, a *cluster* chart will show these groups next to one another as groups of horizontal bars. Drag and drop your chart object to the desired location in the sheet.

Modifying Bar Graphs

Step 1

Switch row and column data.

Click anywhere in the chart area to modify the chart. A common change is to swap the data measured by the category axis. Select the **Design** tab from the dynamic **Chart Tools** that appear to the right of the View tab. Click **Switch Row/Column Data.** The items in the legend swap with the items in the category axis. Click **Undo** to switch back.

Step 2

Change Colors on the Design tab under Chart Tools.

Changing the overall colors of bar graphs often makes them easier on the eyes. Select the **Design** tab from the dynamic **Chart Tools** that appear to the right of the View tab. Click **Change Colors** and choose a different color scheme.

Format individual chart elements from the Chart Tools.

Formatting individual chart elements is straight-forward. * Click on the element, for example, *Chart Title* or *Category Axis*. * Select **Format** under **Chart Tools**. * Choose the style change you want, for example *Shape Fill* or *Word Art Style*.


  • Clicking on any bar in a bar graph will select an entire series of data. **Be cautious of clicking more than once.** Two single clicks will select a _data point_, rather than a _data series_, which means that changes were made to a single bar only. Save yourself the extra work by learning to click away from the chart and then back in when you select the wrong chart element.


  • Double-clicking on any element in your graph opens the Formatting Pane for that element on the right side of your screen. Right-clicking is another fast method for quick formatting.


Photo Credits

  • Photo courtesy of Microsoft

About the Author

Jenny Hansen has trained on technology for 20 years, working at Fortune 500 companies such as Xerox, Nestle Foods and Capital Group. She is a technical writer and member of the Microsoft Insiders User Group and does social media and blogging for a variety of industries.

More Articles