Data Properties dialog box

The Data Properties dialog box controls how your spreadsheet data appears in your chart. You can add data labels to identify the value of markers, such as pie slices or bars, adjust the spacing between columns in a bar chart, and change the data series on your chart from rows to columns.

Do Not Display

Enable to hide the titles for the data markers (text or values) on your chart.

Display Value

Enable to display each data marker's numeric value.

Display Labels

Enable to display text on the data marker. For example, the date the data was collected.

Column Gap

Specifies the amount of space between columns. This option applies only to bar charts. Adjusting the space between the markers has no effect on their size or on the size of your chart.

Rows

Enable to display horizontal rows in the spreadsheet as series of data markers on the chart.

Columns

Enable to display vertical columns in the spreadsheet as series of data markers on the chart.

Column

Displays a list of the data labels in your chart. Select a data label in this box, then use the Fill box and the Border options to change its color and its border style.

Fill

Displays a color palette, where you can choose a color for the data label selected in the Column list box.

Display Border

Enable to display a border around the data label selected in the Column list box.

Border Thickness

Specifies the thickness of the border displayed around the data label selected in the Column list box.

Border Color

Displays a color palette, where you can choose a color for the border around the data label selected in the Column list box.