Specify where labels appear: Click the Location pop-up menu and choose an option, such as Top, Middle, Above, or Inside (the options depend on your chart type). It’s added to the beginning or end of the label. Show the thousands separator: Select the Thousands Separator checkbox.Ī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 checkbox 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 checkbox 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 checkbox next to Values, then click the Value Data Format pop-up menu and choose an option.įor other types of charts: 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |