Excel® 2013 On Demand

Formatting Line and Bar Charts

If you’re using a line or bar chart, you can add trendlines, series lines, drop lines, high-low lines, up/down bars, or error bars with different options to make the chart easier to read. Trendlines are graphical representations of trends in data that you can use to analyze problems of prediction. For example, you can add a trendline to forecast a trend toward rising revenue. Series lines connect data series in 2-D stacked bar and column charts. Drop lines extend a data point to a category in a line or area chart, which makes it easy to see where data markers begin and end. High-low lines display the highest to the lowest value in each category in 2-D charts. Stock charts are examples of high-low lines and up/down ...