For example, you could survey a team of employees about working conditions and make a pie graph based on the results. Pie/doughnut: Pie charts can help show how different categories make up a whole, with all data adding up to 100%. Here are some of the popular chart options. There are many kinds of graphs and charts in Excel. What other types of graphs can I create using “Insert Chart?” Note, this formatting is as essential to learn as multiple IF statements in Excel, which you can learn more about on Udemy. Rows are horizontal entries that start from 1 to 9,999. In a traditional data chart, column A holds the character name, and column B carries all numbers. In Excel, you can identify columns using a letter system. Feel free to click and drag it elsewhere to make it easier to see the data table and bar graph separately. The bar graph will automatically appear in the worksheet, superimposed, or floating on top of your existing data.

Once you find the bar graph style your wish to use, click on the icon.

Make a pie chart in excel 2013