FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To show a percentage on a slice of a pie chart, use this tab in the Format Data Series Dialog Box:
A
Axes
B
Gridline
C
Data Labels
D
Data Table
Explanation: 

Detailed explanation-1: -Reading Pie Charts To calculate the percentage each slice is worth, measure the angle of each slice and divide this by 360 then multiply it by 100 . To find the number of pieces of data each slice represents, multiply the percentage that each slice is worth by the total number of the data sets.

Detailed explanation-2: -To display percentage values as labels on a pie chart On the design surface, right-click on the pie and select Show Data Labels. The data labels should appear within each slice on the pie chart.

Detailed explanation-3: -Right click the pie chart again and select Format Data Labels from the right-clicking menu. 4. In the opening Format Data Labels pane, check the Percentage box and uncheck the Value box in the Label Options section.

There is 1 question to complete.
Previous
Next