Excel offers a one-click option on its "Insert" menu to take data on a spreadsheet and render it in a visual aid format.

On the Format Data Labels pane, select the Value or the Percentage box or both. Read: How to create a Lollipop Chart in Excel We hope you understand how to create a chart with crayon effect in Excel.

Right-click the pie chart and select "Add Data Labels." Labels appear on the chart segments showing their values. Right-click the chart again and select "Format Data Labels." A dialog box opens.

Right-click one of the remaining data labels and choose Format Data Labels. Click the Alignment tab. Choose Inside Base in the Label Position section.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.