Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
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.
There are currently no FAQs about Excel 2007: Charts in Depth.
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.