On the Format tab, in the Current Selection group, click Format Selection. This displays the Chart Tools, adding the Design, Layout, and Format tabs. To display additional label entries for a single data point, click the data label in the data point that you want to change, and then click the data label again. To display additional label entries for all data points of a series, click a data label one time to select all data labels of the data series. Select the existing text and then type the replacement text. The cell values will now display as data labels in your chart.Ĭhange the text displayed in the data labelsĬlick the data label with the text to change and then click it again, so that it's the only data label selected. When you do that, the selected range will appear in the Data Label Range dialog box. When the Data Label Range dialog box appears, go back to the spreadsheet and select the range for which you want the cell values to display as data labels. You can use cell values as data labels for your chart.Ĭlick Label Options and under Label Contains, select the Values From Cells checkbox.
#Line graph in word 2017 online series#
Right-click the data series or data label to display more data for, and then click Format Data Labels.Ĭlick Label Options and under Label Contains, pick the options you want. In this line graph, the x-axis measured different school years.Tip: If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want. Typically, the x-axis has numbers representing different time periods or names of things being compared. In line graphs, like the one above, the x-axis runs horizontally (flat). In this graph, two sets of data are presented. Line graphs can present more than one group of data at a time. The most important part of your graph is the information, or data, it contains. In this line graph, the y-axis is measuring the amount of money spent on individual students for public education. The y-axis usually starts counting at 0 and can be divided into as many equal parts as you want to. Typically, the y-axis has numbers for the amount of stuff being measured. In line graphs, the y-axis runs vertically (up and down). It is important to give credit to those who collected your data! In this graph, the source tells us that we found our information from NCES. The source explains where you found the information that is in your graph. This legend tells us that the green line represents the actual dollar amount spent on each child and the purple line represents the amount spent when adjusted for inflation. Just like on a map, the legend helps the reader understand what they are looking at. The legend tells what each line represents. The title of this graph tells the reader that the graph contains information about the changes in money spent on students of elementary and secondary schools from 1961 to 2002. It can be creative or simple as long as it tells what is in the graph. This helps the reader identify what they are about to look at. The title offers a short explanation of what is in your graph. The following pages describe the different parts of a line graph. Line graphs are good for plotting data that has peaks (ups) and valleys (downs), or that was collected in a short time period. Line graphs can be used to show how something changes over time. What are Independent and Dependant Variables? How to Choose Which Type of Graph to Use?
0 kommentar(er)
