Adding drop lines


show more Adding drop lines provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Adding drop lines

For chart series that have many data points, perhaps like the line charge that we're seeing here, you can add a feature called drop lines that improve the readability of the values here. If we could drop lines from each point here down to the axis, we can more readily see which point is associated with which time period. So you don't even have to select the line; just select the chart and then on the Layout tab, the choice under Lines > Drop Lines. We see what's happening there. The more points you have, the more likely this is to be useful.

Now what might be a little annoying here is that the tick lines don't necessarily match up with those, and they look like they are sort of obtrusive. You could either get rid of them or make an adjustment here simply by right-clicking anywhere down on the horizontal axis here. Right-click, go to Format Axis, and then for the tick lines, how about Position Axis, On tick marks? Watch the display change. We'll see what's happ...

Adding drop lines
Video duration: 3m 14s 3h 36m Intermediate

Viewers:

Adding drop lines provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...