Column and bar charts are used to compare different items or identify changes over time. Column charts feature a vertical display of data. Bar charts format data horizontally.
Stacked charts allow you to draw attention to specific segments of data. Combo charts give you all of the display capabilities of column, bar and stacked charts with an added line to highlight a particular trend.
The orientation of column, bar, stacked and combo charts can be switched from column (vertical) to bar (horizontal). Use the Orientation [ ] icons in the Chart Properties panel to switch from one to the other.
Column and group spacing
Use the Chart Properties panel to control column width. You’ll find the Bar Padding feature in the Series section. If you increase Bar Padding setting, the space between the bars will increase. The width of the bars themselves will decrease proportionately.
Conversely, if you decrease the Bar Group Padding, the space will decrease. The width of the bars will increase. The Bar Group Padding functions in a similar way. You can increase and decrease the spacing to get your desired display.
Note: Overlapping bars can be created using negative padding values.
You can also insert columns to show totals. For example, this could show all four quarters for a year. To insert total columns:
- First insert a blank column to separate the data for the year total from the data for the quarters. This will create a space in the chart.
- Create a column for the year-end totals.
- Use a SUM formula in each cell in the Total column.
Customize a series
To customize a series:
- Select the series in the chart or using the drop-down menu in the Chart Properties panel.
- Click the square for Color to customize the column or bar color using the color picker.
- Toggle the Border slider to customize the column or bar borders. Use the input box to set the thickness of the border. Click the Line Border icon to change the color of the column or bar border.
- Choose the Dash Style in the drop-down menu.
Customize a single column or bar
To customize a single column or bar:
- Select the series in the chart or use the first drop-down menu under Series.
- Then select the specific column or bar in the chart or use the second drop-down menu under Series.
- Customize the color and border in the Chart Properties panel.
- Then choose a color from the color picker for that column.
To create a border for a column or segment of a stacked column or bar chart:
- Select the column, slice or portion of a stacked column or bar in the chart.
- Use the toggle to turn on the Border feature.
- Enter a number for the border width in pixels.
- Use the Line Color icon to choose a color.
Note: When you create a border around a column, bar or a portion of a stacked chart, a border is also created around that value in the legend for easy identification.
Combo charts give you all of the display capabilities of column, bar and stacked charts with an added line to highlight a particular trend. Combo charts can be customized by working with either the columns or the line or both.
Use the Chart Properties panel to change the column colors, borders and label positions. Then select the line to work with the line color, markers and line style.