Excel Tip of the Day
Clarify data on line and area chart with drop lines (Excel 97/2000/2001/2002)
Although Excel's 3-D charts do a pretty good job of simulating 3-D objects on a 2-D screen, it can sometimes be difficult to visually line up a data point with its corresponding position on the chart's category axis. This is especially true when working with area or line charts. The task can be even more difficult if the chart has been rotated or the perceived angle of elevation has been changed. Fortunately, you can add drop lines, which are visual aids that help anchor each data point to the category axis.
To display drop lines, select a data series on the chart and then choose Format | Selected Data Series from the menu bar. Then, click on the Options tab. Select the Drop Lines check box and then click OK. Vertical lines now extend from each data point to the category axis, eliminating confusion and guesswork. Note that this formatting option can also be applied to 2-D area and line charts.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.