how to create pie chart in excel from text

Now, another thing I could do with the smallest pie sections is pull them out, like a detail. It rotates the pieces to the right and moves the labels away from the title. I’ll right-click the chart, and click Format Data Series.įor the angle of the first slice, I’ll click the up arrow and change the angle from 0 degrees to 80 degrees. To fix that, I can rotate the pie slices. I like the labels, though the ones at the top are crowded under the title. So, in the pane, I’ll check Category Name.Ī name and percentage now show in the data label. I’d also like to show the Salesperson’s name. In the labels, the dollar amounts are replaced with percentages. So, I’ll click Undo, go back to LABEL OPTIONS, check Percentage, and uncheck Value. On second thought, I like the idea of showing percentages. That adds the dollar symbol and decimal places to the label. Under Category, I’ll click the arrow and choose Currency. To add a dollar symbol to these values, I can scroll down in the pane and click NUMBER. Right now, Value is selected, so the labels show the dollar values I entered, when I created the chart. Under LABEL OPTIONS, I select what I want the label to show. I’ll click More Options to see what those are.

Here’s Center, Inside End - which appears to be the default - Outside End, Best Fit, and Data Callout, which includes the Salesperson’s name and shows a percentage instead of a dollar amount.

Then, I’ll click the arrow next to Data Labels and point to other options for label position. Let’s check the Data Labels box to display the labels. The Data Labels preview on the chart, showing an Order Amount in each section. I’ll click the top one, Chart Elements, and in CHART ELEMENTS, point to Data Labels.

Now let’s customize the chart, so it has the details and style we want.įirst, to show the value of each pie section, we’ll add data labels to the pieces.

How to create pie chart in excel from text