how to make a pie chart in excel with names

To filter the data in a chart, click the Chart Filter button, uncheck items you don't want to display, and click Apply. I get a live preview when I point to an option. When I click the arrow beside Data Labels, I get options for where to place them. If I checked Data Labels, it would put the values above the markers, which is a little confusing. I click the Chart Elements button, point to Axis Titles, click the arrow beside it, check Primary Vertical, and type Inches into the title text box.ĭata labels would make the chart easier to fully comprehend. I also want to add a title for the vertical axis of the chart, the numbers, so people will know what they represent. Lastly, we are customizing the line chart we created in the previous video. It looks good, so I click OK.Īnd now we have a chart that does a great job of presenting the data.

Instead, I right-click the chart, click Change Chart Type, click Column. Now that I have seen the data charted, I think a column chart would work better.īut I don't have to delete this chart and create a new one from scratch.

To change the data series for the chart, right-click the chart, click Select Data in the right-click menu, select the Chart data range and click OK. I check Data Table and it is added to the chart.

The bar chart has more elements than the pie chart. Select the chart, click the Chart Elements button. Now we are customizing the bar chart we created in the previous video. I think this one looks good, so I click it. When you point to an option, you see a preview of what it'll look like. But the overall look of the chart isn't exactly what I want. I click Percentage, and the data labels now contain what I want. The Format Data Labels task pane appears.Ī task pane provides you with more options for customizing elements. None of them give me what I want, so I click More Options. I can point to each option and see a preview. To do that, click the arrow beside Data Labels. They look pretty good, but I want the labels to include Sales as a dollar value and as a percent of the total. To add data labels, you check Data Labels. The Chart Elements, Chart Styles, and Chart Filter buttons appear next to the chart.Ĭlick the Chart Elements button and check or uncheck the elements you want to add or remove, such as Chart Title.ĭifferent chart types have different elements, styles, and filters. To add elements to your chart, such as a title and data labels, select the chart. If there isn't a chart title, I'll show you how to add one next. When you select a title or label's text, you get a context sensitive menu that enables you to change its formatting, such as Font, Font Size, and Font Color. To change the title, click it, and type the text you want. We are customizing the pie chart we created in the previous video. After you create your chart, you can customize it to show additional chart elements, such as titles and data labels, or to make it look exactly the way you want.

How to make a pie chart in excel with names