To make changes in a chart, we need to make changes in the corresponding ________.
Share
To make changes in a chart, we need to make changes in the corresponding ________.
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
Chart Area
...................
Answer:
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
You can also edit titles and labels that are independent of your worksheet data, do so directly on the chart and use rich-text formatting to make them look better.
Note that you can edit titles and data labels that are linked to worksheet data in the corresponding worksheet cells. If, for example, you change the title in a cell from "Yearly Revenue" to "Annual Revenue" — that change will automatically appear in the titles and data labels on the chart. You won't, however, be able to use rich-text formatting when you make a change from within a cell.
When you edit a linked title or data label on the chart (instead of within a cell), that title or data label will no longer be linked to the corresponding worksheet cell, and the changes that you make are not displayed in the worksheet itself (although you will see them on the chart). However, you can reestablish links between titles or data labels and worksheet cells.
After you finish editing the text, you can move the data labels to different positions as needed.
Note: To make any of the changes described below, a chart must already have titles or data labels. To learn to add them, see Add or remove titles in a chart and Add or remove data labels in a chart.
What do you want to do?
Edit the contents of a title or data label on the chart
Edit the contents of a title or data label that is linked to data on the worksheet
Reestablish the link between a title or data label and a worksheet cell
Change the position of data labels
Edit the contents of a title or data label on the 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