How Excel makes a double pie chart

Source: Internet
Author: User

How does Excel make a double pie chart? We all know that pie charts reflect a proportion of the overall relationship, in the use of the process can be based on their own needs to make, and sometimes in order to more highlighting the proportion of data relationship, the need to make a double pie, then how to make a double pie chart, the following for you to introduce a detailed, to see.


Steps

Start excel2003, open the prepared data, select cell B3, execute the Insert-function command, select the data area D3:d8 Click the OK button, the total number of seven grade is calculated, the same reason to calculate the eight grade and nine grade number.

Select A3:b5 this takes the data range, executes the Insert-Chart command, selects the pie chart in the Chart Wizard that pops up, selects the first in the child chart type, and then clicks Next.

In step 2 of the Chart Wizard, the data area in the pop-up dialog box refers to the =sheet1! $A $: $B $. Then click on the Series tab.

In the Series tab, click the Add button in the series to produce a series 2 in the series, select =sheet1! in the value $D $: $D $. Click Next.

In step 3 of the Chart Wizard, click the Legend tab, where the check mark in the front square of the show legend is canceled.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.