Fine Beautiful Add A Line To Bar Chart Excel

Click the worksheet that contains your chart.

Add a line to bar chart excel. The reason why I do this is to use the vertical column to highlight a specific point in the Excel chart whilst I am presenting the data to my stakeholders. A trendline can be added to a variety of Excel charts including XY scatter bubble stock as well as unstacked 2-D bar column area and line graphs. Right click on the added series and change its chart type to XY Scatter With Straight Lines And Markers again the markers are temporary.

Under Chart Tools on the Design tab in the Data group choose Select Data. In the Change Chart Type dialog box make sure Combo Custom Combination template is selected which should be by default. To create a vertical line in your Excel chart please follow these steps.

We need to show the target value as a horizontal line in the graph. In some empty cells set up the data for the vertical line like shown below. First we insert two bar graphs.

First of all select the data table and insert a column chart. Select your data and make a bar chart Insert tab Charts group Insert Column or Bar chart 2-D Bar. In this example I show you how easy it is to add vertical date line excel chart sprinkled with a little magic.

In the popup menu. Below there is an example of a scatter plot with an extended trendline. In Excel it is very easy to add vertical date line Excel chart and make it interactive with a Scroll Bar.

The target line series is added to the graph orange bars in the screenshot below. In the popped out Change Chart Type dialog select X Y Scatter Scatter with Straight Lines and click OK to exit the dialog. Then select the new series you added in the bar chart and right click to click Change Series Chart Type in context menu.