You can also embed an existing Excel chart into your Word document.
Just open the spreadsheet in Excel, copy the data, then paste it as the source data in Word. If you already have data in an existing Excel file that you'd like to use in Word, you can copy and paste it instead of entering it by hand. Charts contain several different elements-or parts-that can help you interpret data.Ĭlick the buttons in the interactive below to learn about the different parts of a chart.
#Month in axis scatter chart excel 2016 how to
In addition to chart types, you'll need to understand how to read a chart. 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 rather than 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 Word.Ĭolumn charts use vertical bars to represent data. Word has a variety of chart types, each with its own advantages. To use charts effectively, you'll need to understand what makes each one unique.Ĭlick the arrows in the slideshow below to learn more about the types of charts in Word. There are several types of charts to choose from.