How to add a single vertical bar to a Microsoft Excel ... than one chart type in the same chart. For example, you might add a line to a bar chart, using the line chart to show an average or ...

The resulting chart needs to automatically update to reflect the new average. Fortunately, Excel automates most of these tasks as long as you set up your spreadsheet correctly. How to Add Data in ...

Include the header text so Excel can generate a legend automatically. Click Insert and then click Insert Column Or Bar Chart in the Charts group. Choose the first option in the first line.