Question

make a chart displaying various data types

Answer 1

Present data in a chart

Word for Office 365 Word 2019 More...

If Excel is installed on your computer, you can take advantage of the advanced charting capabilities in Word.

What do you want to do?

Learn about charts

Step 1: Create a basic chart

Insert a chart by embedding it into your document

Paste a linked Excel chart into your document

Arrange the Excel worksheet data

Step 2: Change the layout or style of a chart

Apply a predefined chart layout

Apply a predefined chart style

Change the format of chart elements manually

Step 3: Add or remove titles or data labels

Add a chart title

Add axis titles

Add data labels

Step 4: Show or hide a legend

Step 5: Display or hide primary chart axes or gridlines

Step 6: Move or resize a chart

Move a chart

Resize a chart

Step 7: Save a chart as a template

Learn about charts

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.



1. Worksheet data

2. Chart created from worksheet data

Excel supports many types of charts to help you display data in ways that are meaningful to your audience. When you create a chart or change an existing chart, you can select from a variety of chart types (such as a column chart or a pie chart) and their subtypes (such as a stacked column chart or a pie in 3-D chart). You can also create a combination chart by using more than one chart type in your chart.



Example of a combination chart that uses a column and line chart type.

For more information about the chart types that you can select in Excel, see Available chart types.

Getting to know the elements of a chart

A chart has many elements. Some of these elements are displayed by default, others can be added as needed. You can change the display of the chart elements by moving them to other locations in the chart, resizing them, or by changing the format. You can also remove chart elements that you do not want to display.



1. The chart area of the chart.

2. The plot area of the chart.

3. The data points of the data series that are plotted in the chart.

4. The horizontal (category) and vertical (value) axis along which the data is plotted in the chart.

5. The legend of the chart.

6. A chart and axis title that you can use in the chart.

7. A data label that you can use to identify the details of a data point in a data series.

Modifying a basic chart to meet your needs

After you create a chart, you can modify any one of its elements. For example, you might want to change the way that axes are displayed, add a chart title, move or hide the legend, or display additional chart elements.

To modify a chart, you can:

Change the display of chart axes    You can specify the scale of axes and adjust the interval between the values or categories that are displayed. To make your chart easier to read, you can also add tick marks to an axis, and specify the interval at which they will appear.

Add titles and data labels to a chart    To help clarify the information that appears in your chart, you can add a chart title, axis titles, and data labels.

Add a legend or data table     You can show or hide a legend, change its location, or modify the legend entries. In some charts, you can also show a data table that displays the legend keys and the values that are presented in the chart.

Apply special options for each chart type    Special lines (such as high-low lines and trendlines), bars (such as up-down bars and error bars), data markers, and other options are available for different chart types