Home > Articles

This chapter is from the book

This chapter is from the book

Formatting Line and Bar Charts

EX07S-4.1.2, PP07S-3.6.3

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 bars. Error bars show potential error amounts graphically relative to each data marker in a data series. Error bars are usually used in statistical or scientific data.

Format Line and Bar Charts

yellow_circle_1.gif Select the line or bar chart you want to modify.

yellow_circle_2.gif Click the Layout tab under Chart Tools.

yellow_circle_3.gif In the Analysis group, click any of the following:

  • Trendline to remove or add different types of trendlines: Linear, Exponential, Linear Forecast, and Two Period Moving Average.
  • Lines to hide Drop Lines, High-Low Lines or Series Lines, or show series lines on a 2-D stacked Bar/Column Pie or Pie or Bar of Pie chart.
  • Up/Down Bars to hide Up/Down Bars, or show Up/Down Bars on a line chart.
  • Error Bars to hide error bars or show error bars with using Standard Error, Percentage, or Standard Deviation.
  • + Share This
  • 🔖 Save To Your Account