Display chart based on single fraction

[rovert]

Hi All,

I have a Excel workbook to help my son with fractions, what i want to do is have a list of fractions (see below) and a pie chart to show how much of a whole that fraction is.

1/5, 1/3, 1/2, 3/4

Is this possible?

 

[Jon von der Heyden]

Hi

I love this question!

See my exhibit below:

Formula in A2 and copied down: =TEXT(B2,"# ?/?")
Enter fractions in B2:B5 and format as # ?/?
Formula in C2 and copied down: =1-B2

Next highlight A1:C5
Go Insert > Recommended Charts
Choose Stacked Column
Click OK

 

[Jon von der Heyden]

Sorry - just realised you want a pie chart. You could add a pie chart for each row if you want, and you will get the desired illustration. This based on A2:C2.