How Excel chart titles add and reference cells

Source: Internet
Author: User
Tags contains

First, the default Excel chart title

The default Excel chart title is to add a chart title by selecting the chart, clicking Chart Tools-layout-chart title, selecting the Center overlay title item as needed, and so on. As shown in the following illustration:

Excel default chart title, you cannot change the caption size by dragging, the default caption is not as wide as the chart, and there are many limitations to text layout.

Second, the Excel chart title references

If there is already a caption text in the cell. When we're making a chart, there's no need to repeat the typing, and the Excel chart title can refer to the cell contents.

The Excel Chart Title reference method is: Click the chart title, and then type in the formula bar: = The cell reference address that contains the caption content, and press ENTER to generate a chart title that is the same as the cell link.

If we modify the contents of the cell that contains the title, the chart title will change accordingly.

Third, the text box replaces the Excel chart title box

In the chart area, free up the position to insert the chart title, activate the chart, select the chart tool--layout--text box, insert the text box, drag and drop the adjustment, so that it and the chart and the top close to coincide.

The text boxes and charts that you insert by using the Chart tool-layout-text box described above are a whole, and the text box does not break out of the chart when the chart moves.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.