Change Format Of Data Labels In Chart. On a chart do one of the following. To edit the contents of a title click the chart or axis title that you want to change.
Please click the Date column in the Fields panel of the above screenshot then you can click on Modeling in the Desktop ribbon and change the date format to your desired format. Now click on any data label. To change the labels font and background color select them go to the Format tab on the ribbon and choose the formatting options you want.
To edit the contents of a title click the chart or axis title that you want to change.
I have the data in column A and B with years and amounts respectively. A variety of macros is available. Setup chart and have data labels turned on on your chart. To change the labels font and background color select them go to the Format tab on the ribbon and choose the formatting options you want.