Format Line and Bar Charts : Chart Format Style « Chart « Microsoft Office Excel 2007 Tutorial






Select the line or bar chart. 
           Click the Layout tab under Chart Tools.
Select the line or bar chart. Click the Layout tab under Chart Tools.
Click Trendline to remove or add trendlines: 
           Linear, Exponential, Linear Forecast, and Two Period Moving Average.
Click Trendline to remove or add trendlines: Linear, Exponential, Linear Forecast, and Two Period Moving Average.
Click Lines to hide Drop Lines, High-Low Lines or Series Lines.
Click Lines to hide Drop Lines, High-Low Lines or Series Lines.
Click Up/Down Bars to hide or show Up/Down Bars.
Click Up/Down Bars to hide or show Up/Down Bars.
Click Error Bars to hide/show error bars with using Standard Error, Percentage, or Standard Deviation.
Click Error Bars to hide/show error bars with using Standard Error, Percentage, or Standard Deviation.








5.3.Chart Format Style
5.3.1.Format a Chart ObjectFormat a Chart Object
5.3.2.Apply a Chart StyleApply a Chart Style
5.3.3.Apply a Chart LayoutApply a Chart Layout
5.3.4.Apply a Shape Style to a Chart ObjectApply a Shape Style to a Chart Object
5.3.5.Format Line and Bar ChartsFormat Line and Bar Charts
5.3.6.Change the Chart BackgroundChange the Chart Background
5.3.7.Format Chart TextFormat Chart Text
5.3.8.Insert a Picture, Shape, or TextInsert a Picture, Shape, or Text
5.3.9.Reset chart formattingReset chart formatting