Select Secondary Vertical (Value) Axis.On the Axis Options tab, under Axis Options, in Minimum, click Fixed, input value 0, in Maximum, click Fixed, input value 6000, in Major unit, click Fixed, and input value 1000.įormatting Secondary Vertical (Value) Axis.Press CTRL+1. The Format Axis dialog box is displayed.On the Line Color tab, under Line Color, click No line.under Position Axis, click On tick marks, then Click Close. On the Axis Options tab, In Major tick mark type, select None.Select Secondary Horizontal (Category) Axis.Click Secondary Horizontal Axis, and then click Show Left to Right Axis.On the Layout tab, in the Axes group, click Axes.On the Series Options tab, under Plot Series On, click Secondary Axis, then Click Close.
On the Layout tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Series "Average". Select the chart, this displays Chart Tools. In the Change Chart Type dialog, choose a basic Line chart. Right-click any of the columns in the Average series on the chart, In the quick menu, click Change Series Chart Type…. Under the Insert menu tab, in the Charts group, click the Column button and choose Clustered Column in 2-D Column. In Column C2, type this formula: =AVERAGE($B$2:$B$7) We'll use Average function to calculate the average of entire group. We want to display the average sales for the group in our chart, so we need to insert a new Helper Column that we called Average. You may copy A1:C7 to a new Worksheet to start this tutorial. In this example, we have a group of sales data (range A1:B7). In this tutorial, I'll show you how to add an Average Line to Column Chart in Excel 2010. When you create a chart to analyze the trend of the data, it is useful to add a horizontal Average Line across the chart, so that you can compare the data clearly and easily.
0 kommentar(er)
