How Excel makes beautiful dynamic doughnut charts

Source: Internet
Author: User
Tags first row

How Excel makes beautiful dynamic doughnut charts

The data are as follows:

Drawing steps:

First, insert a control button.

Development tool--insert--combo box.

How the development tool brings up: file--Options--Custom Ribbon--Main tab--development tool (tick).

After drawing, click the control right--set the control format.

When you set a control, the number of linked cells changes as you select the Drop-down box for the control.

The returned number is the relative position of the selected data in the control in the range, consistent with the result returned by the match function.

Effect:

Build the data.

Copy the table title, go to A9:e9, enter the formula in A9, and pull right.

Formula Resolution:

Use index to extract the data for the first row, $B 7 cell is the control-linked cell, and the data changes as the control changes.

In A11 cell enter: Blank placeholder.

Enter the formula in the B11 and pull right:

This assumes that the maximum value of a circle is 650.

To create a chart:

Select the built data insert-doughnut chart.

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.