Contents
Does a line graph show change over time?
Line graphs are used to track changes over short and long periods of time. When smaller changes exist, line graphs are better to use than bar graphs. Line graphs can also be used to compare changes over the same period of time for more than one group.
On what axis should time be located on a line graph?
x-axis
Time is the independent variable and will always be placed on the x-axis. The lines on the graphs can tell you many different things. For example: The slope of a line (steepness) can tell you speed.
How should graph axis be labeled?
The proper form for a graph title is “y-axis variable vs. x-axis variable.” For example, if you were comparing the the amount of fertilizer to how much a plant grew, the amount of fertilizer would be the independent, or x-axis variable and the growth would be the dependent, or y-axis variable.
How do you label time on a graph?
To specify the labels to use when you create a graph, click Time/Scale, then specify the labels on the Time tab. To change or add the labels on an existing graph, double-click the x-scale, then specify the labels on the Time tab. Select the labels to use on the time scale.
What does a straight line represent on a distance vs time graph?
A distance-time graph shows how far an object has travelled in a given time. ‘Straight lines’ on a distance-time graph tell us that the object is travelling at a constant speed. Note that you can think of a stationary object (not moving) as travelling at a constant speed of 0 m/s.
How to change axis labels in a chart?
The chart uses text from your source data for axis labels. To change the label, you can change the text in the source data. If you don’t want to change the text of the source data, you can create label text just for the chart you’re working on.
How to label a line in a graph?
Rather than the smoothed-out appearance in the line above, this style subtly emphasizes that there gains and losses over time. Make sure your markers are relatively small; otherwise, the graph can look outdated and clunky. A second option is to remove the axis and label the data points directly.
How to label specific dates in an Excel chart?
When you have data that spans a long period of time that you want to plot in a chart, the dates in the horizontal axis in a line or scatter chart can get very cluttered. With this clever workaround that Jim Fitch shared with me we can trick Excel into showing data correctly spaced over time and only label specific Excel Chart axis dates.
How can I change the title of a chart?
To edit the contents of a title, click the chart or axis title that you want to change. To edit the contents of a data label, click two times on the data label that you want to change. The first click selects the data labels for the whole data series, and the second click selects the individual data label.