Format chart title, legend, data labels, axes labels.

In order to format any of the chart properties, first of all we need to select the chart by double clicking on it, and then right click on the chart area. This gives a menu from which ‘Insert Titles’ can be selected. This gives a ‘Titles’ dialog box from where we can add a title, remove a title and also edit the title. If the title is already there, just delete the title and click on ‘OK’. This will remove the title. Similarly, by changing the title and clicking on ‘OK’, we can edit the title.


chapt-4-1
chapt-4-2
chapt-4-3
chapt-4-4
chapt-4-5
chapt-4-6
chapt-4-7
chapt-4-8
chapt-4-9
chapt-4-10
chapt-4-11
chapt-4-12
chapt-4-13
chapt-4-14
chapt-4-15
chapt-4-16
chapt-4-17
chapt-4-18
chapt-4-19
chapt-4-20
chapt-4-21
chapt-4-22
chapt-4-23
chapt-4-24
chapt-4-25
chapt-4-26
chapt-4-27
chapt-4-28
chapt-4-29
chapt-4-30
chapt-4-31
chapt-4-32
chapt-4-33
chapt-4-34
chapt-4-35
chapt-4-36
chapt-4-37
chapt-4-38
chapt-4-39
chapt-4-40
chapt-4-41
chapt-4-42
chapt-4-43


1-chart-titleTo 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.2-data-labels

If the ‘Show value as number’ checkbox is checked, then the output will be as follows.

3-chartTo change the font size of the chart title, 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 title and from the resulting menu, click on ‘Format Title’. This will display the ‘Main Title’ dialog box.

4-chart-title-fontIn this dialog box, under the ‘Font’ tab, we have a ‘Size’ drop down list. From this list, select the appropriate font size and click on ‘OK’. This will change the font size of the chart title.

In the same dialog box, under the ‘Font Effects’ tab, we have a ‘Font color’ drop down list. From this list, select the appropriate font color and click on ‘OK’. This will change the font color of the chart title.

5-chart-title-font-effectsTo change the font size and color of the chart axes, we need to follow similar steps. 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 axes text and from the resulting menu, click on ‘Format Axis’. Doing this for the x-axis will open the ‘X Axis’ dialog box whereas doing these same steps for the y-axis will display the ‘Y Axis’ dialog box.

In both these dialog boxes, we have the ‘Font’ and ‘Font Effects’ tabs. These tabs have the same functionality as we have seen above for some similar dialog boxes. We have the ‘Size’ and ‘Font color’ drop-down lists in these dialog boxes from where we can choose the appropriate font color and font size for the axes text.

6-chart-title-x-axis7-chart-title-y-axisTo change the font size and font color for the legend text, we need to follow similar steps as we have seen above. First select the chart and then right-click on the legend text area and from the resulting menu, click on ‘Format Legend’. This will open the ‘Legend’ dialog box.

In this dialog box, we have the same ‘Font’ and ‘Font Effects’ tabs under which we have the ‘Size’ and ‘Font color’ drop-down lists. The appropriate values can be selected from these lists. After this, click on ‘OK’. This will change the font size and font color for the legend text.8-chart-legend


Comments

Advanced Presentations – Using Charts — 14 Comments

  1. People appreciates the good courses that you offer, it is just unfortunate I never tried them.

    from now onward I complete any course and thank for that once more.

  2. Amazing i just want to thank my tutor for this wonderful lesson. May Good God grant you more knowledge so that we continue learning from you .

Leave a Reply

Your email address will not be published. Required fields are marked *