Pie and doughnut charts in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a pie chart from data in cells A1 to B5.

Excel

ActiveSheet.Shapes.AddChart2(251, [1], Left:=100, Top:=50, Width:=300, Height:=300).Chart.SetSourceData Source:=Range("A1:B5")

Drag options to blanks, or click blank then click option'

AxlLine

BxlColumnClustered

CxlPie

DxlBarClustered

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column or bar chart type instead of pie chart.

The xlPie constant creates a pie chart in Excel VBA.

2fill in blank

medium

Complete the code to add a doughnut chart using the ChartType property.

Excel

Dim cht As Chart
Set cht = ActiveSheet.Shapes.AddChart2(251).Chart
cht.ChartType = [1]

Drag options to blanks, or click blank then click option'

AxlPie

BxlDoughnut

CxlArea

DxlScatter

Attempts:

3 left

💡 Hint

Common Mistakes

Using pie chart type instead of doughnut.

The xlDoughnut constant sets the chart type to a doughnut chart.

3fill in blank

hard

Fix the error in the code to set the chart title for a pie chart.

Excel

ActiveSheet.ChartObjects(1).Chart.ChartTitle.Text = [1]

Drag options to blanks, or click blank then click option'

ASales Data

B'Sales Data'

CSales_Data

D"Sales Data"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put quotes around the string.

The chart title text must be a string enclosed in double quotes in VBA.

4fill in blank

hard

Fill both blanks to create a pie chart and set its data source to range A1:B4.

Excel

Dim chartObj As ChartObject
Set chartObj = ActiveSheet.ChartObjects.Add(Left:=100, Top:=50, Width:=300, Height:=300)
chartObj.Chart.ChartType = [1]
chartObj.Chart.SetSourceData Source:=Range([2])

Drag options to blanks, or click blank then click option'

AxlPie

BxlBarClustered

C"A1:B4"

D"A1:C4"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong chart type or incorrect range string.

Use xlPie for pie chart type and specify the data range as a string with quotes.

5fill in blank

hard

Fill all three blanks to create a doughnut chart, set its data source, and add a chart title.

Excel

Dim chObj As ChartObject
Set chObj = ActiveSheet.ChartObjects.Add(Left:=50, Top:=50, Width:=350, Height:=350)
chObj.Chart.ChartType = [1]
chObj.Chart.SetSourceData Source:=Range([2])
chObj.Chart.ChartTitle.Text = [3]

Drag options to blanks, or click blank then click option'

AxlDoughnut

B"B1:C6"

C"Sales Overview"

DxlLine

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong chart type or missing quotes around strings.

Use xlDoughnut for doughnut chart, specify the data range as a string, and set the title text with quotes.

Practice

1. What is the main purpose of a pie chart in Excel?

easy

A. To display data trends over time

B. To compare two sets of data side by side

C. To show parts of a whole as slices of a circle

D. To list data in rows and columns

Solution

1. Step 1: Understand pie chart basics

   A pie chart divides a circle into slices representing parts of a whole.

2. Step 2: Compare with other chart types

   Unlike line or bar charts, pie charts focus on showing proportions, not trends or comparisons.

3. Final Answer:

   To show parts of a whole as slices of a circle -> Option C

4. Quick Check:

   Pie chart = parts of whole [OK]

Hint: Pie charts show slices of a circle representing parts [OK]

Common Mistakes:

• Thinking pie charts show trends over time
• Confusing pie charts with bar charts
• Using pie charts for unrelated data types

2. Which of the following is the correct way to insert a doughnut chart in Excel?

easy

A. Select data, press Ctrl+C, then Ctrl+V

B. Select data, go to Insert tab, click on Doughnut chart icon

C. Right-click data and choose 'Create Pie Chart'

D. Use the formula =DOUGHNUTCHART(A1:A5)

Solution

1. Step 1: Locate chart insertion method

   Excel inserts charts from the Insert tab where chart types are listed.

2. Step 2: Identify doughnut chart option

   Under Insert, the Doughnut chart icon is available to create this chart type.

3. Final Answer:

   Select data, go to Insert tab, click on Doughnut chart icon -> Option B

4. Quick Check:

   Insert tab -> Doughnut chart icon [OK]

Hint: Insert tab has all chart types including doughnut [OK]

Common Mistakes:

• Trying to create charts with formulas
• Copy-pasting data instead of inserting charts
• Right-click menu does not create doughnut charts

3. Given this data in cells A1:B4:
Category | Value
Food | 30
Rent | 50
Utilities| 20
What percentage will the 'Rent' slice show in a pie chart?

medium

A. 50%

B. 33.3%

C. 30%

D. 20%

Solution

1. Step 1: Calculate total value

   Total = 30 + 50 + 20 = 100

2. Step 2: Calculate Rent percentage

   Rent = 50; Percentage = (50 / 100) * 100 = 50%

3. Final Answer:

   50% -> Option A

4. Quick Check:

   Rent is half of total = 50% [OK]

Hint: Divide slice value by total sum, multiply by 100 [OK]

Common Mistakes:

• Adding percentages instead of values
• Using wrong total sum
• Confusing category names with values

4. You created a pie chart but the slices do not add up to 100%. What is the most likely cause?

medium

A. Chart is not selected

B. Chart type is set to bar chart

C. Data labels are missing

D. Data includes blank or zero values

Solution

1. Step 1: Check data values

   Blank or zero values reduce total sum, causing slices not to add to 100%.

2. Step 2: Verify chart type and labels

   Bar chart or missing labels do not affect slice percentages adding to 100%.

3. Final Answer:

   Data includes blank or zero values -> Option D

4. Quick Check:

   Missing data affects pie slice totals [OK]

Hint: Check for blanks or zeros in data range [OK]

Common Mistakes:

• Confusing chart type with data issues
• Assuming labels affect slice sums
• Not checking data completeness

5. You want to create a doughnut chart showing sales by region, but also want to highlight the top region slice with a different color. What is the best way to do this in Excel?

hard

A. Create the doughnut chart, then click the top region slice and change its fill color

B. Use a formula to color the slice automatically

C. Insert a pie chart instead and change the chart type later

D. Add data labels and remove the legend

Solution

1. Step 1: Insert doughnut chart with sales data

   Select data and insert a doughnut chart from the Insert tab.

2. Step 2: Highlight top region slice

   Click the slice representing the top region, then change its fill color manually.

3. Final Answer:

   Create the doughnut chart, then click the top region slice and change its fill color -> Option A

4. Quick Check:

   Manual slice color change highlights parts [OK]

Hint: Click slice, then change fill color to highlight [OK]

Common Mistakes:

• Expecting formulas to color slices automatically
• Changing chart type instead of slice color
• Removing legend instead of highlighting slice