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

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.