Adding High-Low Lines and Up and Down Bars
High-low lines are straight lines that extend between the highest and lowest points in a cluster. You can use them to indicate the range over which a value varies. High-low lines are available only in two-dimensional line charts.
Up and down bars are rectangles drawn between the corresponding points of two line series. Excel fills the bars with one color if the first series is higher than the last (the bars in this case are called up bars) and a contrasting color when the opposite is true (in which case they’re called down bars). Up and down bars are often used in charts that track opening and closing prices of securities or commodities.
You can add either high-low lines or up and down bars (or both) by ...
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
