It’s added to the beginning or end of the label. Show the thousands separator: Select the Thousands Separator tickbox.Īdd a prefix or suffix: Enter text. Set the number of decimal places: Click the up or down arrow. To hide the value labels, deselect the Values tickbox or choose None from the pop-up menu.įine-tune the value labels (these controls are available only for some chart types):
You can choose a format for them (for example, number, currency or percentage), change where they appear and more.Ĭlick the chart, then in the Format sidebar, click the Series tab.įor bubble charts: Click the disclosure arrow next to Bubble Labels, select the tickbox next to Values, then click the Value Data Format pop-up menu and choose an option.įor scatter charts: Click the disclosure arrow next to Value Labels, select the tickbox next to Values, then click the Value Data Format pop-up menu and choose an option.įor other types of chart: Click the disclosure arrow next to Value Labels, then click the Value Data Format pop-up menu and choose an option. Charts have labels that show the values of specific data points.
