Step 3 - Highlight data and 'Insert' your desired chart A bar or column graph would have been better suited here. But your audience will most likely be confused because their eyes are expecting the graph to tell a different kind of story.įor example, the above chart is a poor choice to depict this type of data. So if you try to depict employees’ sales figures for one moment in time using a single-line graph where employees’ names are the X-axis values, the line will be plotted. Psychologically, we tend to associate linear images with time. Remember that line graphs are especially useful for showing trends over time. Step 2 - Ensure that a line graph is the right chart for your data type The variable being measured (for example - items sold, daily rainfall, average income, etc.) should be listed next. This will appear on the X-axis of the graph. Whether data is entered in row or column format, the time intervals (days/months/years, etc.) should be listed first. ![]() Here’s how to make a line graph where each category has only one numeric value: Step 1 - Enter and format source dataĪ single line graph means that only one independent variable is being measured or tracked across multiple time intervals. Making a line graph in Excel starts with the basic steps of making any other chart. On a line graph, the numerical value is always placed on the Y (vertical) axis, while the categories (e.g., days, months, years) are placed on the X (horizontal) axis. The chart plots the intersection of x and y numerical values into single data points. ![]() However, the way each of these charts plots data along the X and Y axes is very different.Ī scatter chart always has numerical data on both axes, with the objective of determining a relationship between the two variables. Scatter charts and line graphs are not the same! They may look very similar, especially when a scatter chart is displayed with connecting lines. ![]() Differences between scatter charts and line graphsīefore we really get into it, let’s make sure we are all on the same page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |