![create pie chart in excel 2013 create pie chart in excel 2013](https://i.ytimg.com/vi/azHNZbhu79A/maxresdefault.jpg)
Grid lines – this option is available when you have a chart that supports displaying grid linesįigure 39- change the way the chart looks quickly Up Down Bars – in a Line Chart you can add Up Down Bars to show movement Trend line – again if you have data and the right type of chart this will be live Lines – this will be available if you have a chart that supports it Legend – allows you to add a legend and decide on its placement The Design Ribbon offers you lots of ways to customize the chart and make it your own style.įigure 38- add Chart Elements to make the chart easier to readĬhart Elements allow you to add elements to your chart to make it easier to read or styleĬhart Title – decide if you want a title and where it goesĭata Labels – again you decide how they are placed and whereĭata Table – this depends on the type of chart you are working with – it allows you to add the data underneath the chart – try it out and see
![create pie chart in excel 2013 create pie chart in excel 2013](https://i.ytimg.com/vi/8nHf2r15_2Y/maxresdefault.jpg)
When you have added a chart to your worksheet, you will notice the appearance of two new Ribbon Tabs under the general heading Chart Tools.
![create pie chart in excel 2013 create pie chart in excel 2013](https://www.bluepecantraining.com/wp-content/uploads/2013/09/format-data-series-for-a-pie-of-pie-chart-178x300.jpg)
#CREATE PIE CHART IN EXCEL 2013 HOW TO#
Learn how to create and edit column charts with these easy steps. Charts contain several different elements, or parts, that can help you interpret the data.Ĭlick the buttons in the interactive below to learn about the different parts of a chart.A nice column chart can illustrate your results and convince your audience. In addition to chart types, you'll need to understand how to read a chart.
![create pie chart in excel 2013 create pie chart in excel 2013](https://i.ytimg.com/vi/-Qm9cnxIU8Q/maxresdefault.jpg)
They work best with large data sets, allowing you to see a variety of information at the same time. Surface charts allow you to display data across a 3D landscape. Each value is shown as a slice of the pie, so it's easy to see which values make up the percentage of a whole.īar charts work just like column charts, but they use horizontal bars instead of vertical bars.Īrea charts are similar to line charts, except the areas under the lines are filled in. Pie charts make it easy to compare proportions. The data points are connected with lines, making it easy to see whether values are increasing or decreasing over time. Line charts are ideal for showing trends. They can work with many different types of data, but they're most frequently used for comparing information. Click the arrows to see some of the different types of charts available in Excel.Ĭolumn charts use vertical bars to represent data. In order to use charts effectively, you'll need to understand how different charts are used.Ĭlick the arrows in the slideshow below to learn more about the types of charts in Excel.Įxcel has a variety of chart types, each with its own advantages. Understanding chartsĮxcel has several different types of charts, allowing you to choose the one that best fits your data.
#CREATE PIE CHART IN EXCEL 2013 DOWNLOAD#
Optional: Download our practice workbook.