Data Labels

This page describes the different data labels values and their chart-type compatibility.

There are several available values for the positioning of the data labels.

Name

Value

Center

center

Inside End

inside_end

Inside Base

inside_base

Outside End

outside_end

Left

left

Right

right

Above

above

Below

below

None

none

Not all show_data_labels values are available. Every chart type has some restrictions.

Chart type restrictions

Chart Type

Parameter

Bar

  • center

  • inside_end

  • inside_base

  • outside_end

  • none

Pie

  • center

  • inside_end

  • outside_end

  • none

Line

  • center

  • left

  • right

  • below

  • above

  • none

Column

  • center

  • inside_end

  • inside_base

  • outside_end

  • none

Bar Stacked

  • center

  • inside_end

  • inside_base

  • none

Column Stacked

  • center

  • inside_end

  • inside_base

  • none

Bar Stacked Percent

  • center

  • inside_end

  • inside_base

  • none

Column Stacked Percent

  • center

  • inside_end

  • inside_base

  • none