Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In two-dimensional line charts you might want to compare the differences between two separate series by connecting the high and low points for each specific time period, either with lines or with bars. Both of these features are found in the Analysis group in the Layout tab of the Ribbon. In the line chart that we are looking at, we are comparing Domestic and Latin America, a bit erratic here, the two sets of data. They overlap at different times. Let's point to the Lines button in the Analysis group and choose High Low Lines and see what happens.
So at a glance, you can begin to see the relative differences in the two. Now they are going in opposite directions at different times, so we have to view the information closely to see what's happening, but the gap between the two entries each month varies. In no way would I be suggesting here that these totals always have to be overlapping in any way. In fact many, many times, two series are if not parallel, at least approximately parallel, and sometimes you just want to compare the height of these lines. Another option instead of this--let's take off the Lines, choose None--is under the heading Up/Down Bars, show Up/Down Bars on the Line Chart.
And you can see almost immediately what's happening here. The four bars there that are black represent situations where the Latin American entries below Domestic and the two white ones represent data going in the opposite direction. So it gives you a quick visual read on these differences, and many, many times of course when you are using this feature, the boxes will all be of the same color. So you can use High-Low Lines or Up/Down Bars to show the differences between series in two-dimensional line charts.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 87378 Viewers
80 Video lessons · 136388 Viewers
59 Video lessons · 55031 Viewers
52 Video lessons · 68901 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.