Column / bar charts, Pie charts, Line charts, and Scatter charts. Excel offers many chart type options, however there are four types that are most commonly used.Be sure to include a title and labels for your axes. PIE Chart Options Charts in EXCEL values percentages Values, categoriesĪssignment Create 3 charts in EXCEL Column / bar chart, PIE chart Scatter Chart Use data which is appropriate for each type. Let’s Do a Pie Chart using Hair Color Data Charts in EXCELĪdding a Title and Labels Charts in EXCEL Let’s Do a Pie Chart using Hair Color Data Charts in EXCEL 16 4 6 2 1 Which Chart Type? Charts in EXCEL Column/Bar Line Scatterīut I Want a Bar Chart. Is this the Best Chart for this data? Charts in EXCELĪnother Example Charts in EXCEL US Population DataĬreating your Chart - Review Charts in EXCEL 1 2 Which Chart to Use? Charts in EXCEL 2009 North America Favorite Lunch Calories vs WeightĬreating your Chart – Gather Data Charts in EXCEL 16 4 6 2 1Ĭreating your Chart Enter Data in EXCEL Charts in EXCEL 1 2Ĭreating your Chart Select Chart Type Charts in EXCEL 1 2Ĭreating your Chart Label the Chart Charts in EXCELĬreating your Chart Delete the Key Charts in EXCEL deleteĬreating your Chart Formatting Options Charts in EXCELĬreating your Chart Changing the Text Charts in EXCEL Select text When to use Scatter Charts Charts in EXCEL X axis Y axis When to use Column / Bar Charts Charts in EXCEL Types of Charts Pie Charts in EXCEL Column Bar Line Scatter Use chart options to color and label the chart. Select the appropriate chart for an application. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.Objectives: After viewing this presentation, the learner will be able to: Identify the most frequently used types of charts. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.
#CREATE PIE CHART IN EXCEL 2010 HOW TO#
Output: How to explode a pie chart Instant Connection to an Excel Expert Pull the slice for Bulge and Lip away from the pieįigure 9.
#CREATE PIE CHART IN EXCEL 2010 SERIES#
We can launch Format Data Series by right-clicking the chart and selecting from the menu. Following the same procedure as the example above, we choose the chart type pie of pie and create the resulting graph below. To improve the presentation of our data, we can create a pie of pie chart. There are so many categories in the above pie chart, making it look complicated and harder to read. If we choose to make a 3D pie chart, it will look like this. Click Insert tab, Pie button then choose from the selection of pie chart types: Pie, Exploded Pie, Pie of pie, Bar of pie, or 3D pie chart.First, we select the data we want to graph.Just like any chart, we can easily create a pie chart in Excel version 2013, 2010 or lower. Final result: Pie of pie chart How to create a pie chart? This chart makes the pie chart less complicated and easier to read.įigure 1. It is actually a double pie chart, which displays the parts of a whole through a main pie, while also providing a way to represent the minor slices through another pie. Excel has a built-in chart type called pie of pie chart.