Beautiful Adding An Average Line To A Bar Graph In Excel

There are two main steps in creating a bar and line graph in Excel.

Adding an average line to a bar graph in excel. Updating the Data Set. Supposing you have created a column chart as below screenshot shown and you can add a horizontal average line for it as follows. In order to add a horizontal line in an Excel chart we follow these steps.

In the Format Axis pane under Axis Options type 1 in the Maximum bound box so that out vertical line extends all the way to the top. On the analytics tab of the clustered column visualization you can choose to add an average line. On the Format Data Series pane go to Fill Line tab Line section and select No line.

Now click the Select Data button and click on the Average series. 3 click Insert - Module to create a new module. This article assists all levels of Excel users on how to create a bar and line chart.

You can also write an Excel VBA Macro to add a horizontal average line to an excel chart just do the following steps. Select the measure that you want to average from the dropdown for the measure. Select range A1C7.

First we insert two bar graphs. For this select the average column bar and Go to Design Type Change Chart Type. In your graph double-click the target line.

Bar and Line Graph. Now that we have our data updated with the average column we can create the chart. Bar Chart with Line.