How to Create a Bar Graph in an Excel Spreadsheet

by Jenny Hansen

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

Select Data to Chart.
1

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

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

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

Cluster Bars compare groups of data.
3

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

Switch row and column data.
1

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.

Change Colors on the Design tab under Chart Tools.
2

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.
3

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.

Tip

  • check 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.

Warning

  • close 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.

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.

Photo Credits

  • photo_camera Photo courtesy of Microsoft