Add data labels to a chart: values/numbers, percentages.
To add data labels to a chart, select the chart by double clicking on it. After selecting the chart, click on ‘Insert’ button from the main menu bar and then click on ‘Data Labels’ from the resulting drop down menu. This will open the ‘Data Labels for all Data Series’ wizard. Under ‘Text Attributes’, we can check or uncheck the number or percentage data labels as per the requirement.
Change the background color of a chart.
To change the chart area background color, first of all select the chart by double-clicking on it. A grey border should surround the chart upon selection. After this, right click on the chart area and from the resulting menu, click on ‘Format Chart Area’. This will display the ‘Chart Area’ dialog box.
In this dialog box, under the ‘Area’ tab, we have a ‘Fill’ drop down list. From this list, select the appropriate color which is required for the background of the chart and click on ‘OK’. This will change the chart background color.
Change the column, bar, line, pie slice colors in a chart.
To change the column, bar, line, or pie slice color in a chart, simply double-click on the respective element for which you want to change the color. If it is a bar chart, double-click on the individual bar, and if it is a pie chart, double-click on the pie for which the color is required to be changed. Do likewise for the other chart types. This double-clicking will open the ‘Data Series’ dialog box.
In this dialog box, under the ‘Area’ tab, we have a ‘Fill’ drop down list. From this list, select the appropriate color and click on ‘OK’. This will change the color of the selected element in the chart.