If you'd like to compare the real values with the average or target you wish to achieve, insert a vertical line in a bar graph like shown in the screenshot below:
#ADD ON OFFICE MIX HOW TO#
How to add vertical line to Excel bar chart Depending on your settings in steps 8 and 9, it will look like one of these images: You can also make the line thinner or thicker by changing its Width.ĭone! A vertical line is plotted in your scatter graph. Finally, switch to the Fill & Line tab and choose the Color and Dash type for the currently selected error bar.To display a horizontal line in addition to the vertical line, set Percentage to 100 and choose the desired Direction.To hide the horizontal error bars, set Percentage to 0.
![add on office mix add on office mix](https://library.osu.edu/site/it/files/2017/09/mix-plugin.png)
#ADD ON OFFICE MIX SERIES#
Be sure to delete the existing contents of the Series values boxes first - usually a one element array like =. In this example, we are going to add a vertical average line to Excel chart, so we use the AVERAGE function to find the average of x and y values like shown in the screenshot: Enter the data for the vertical line in separate cells.Select your source data and create a scatter plot in the usual way ( Inset tab > Chats group > Scatter).To add a vertical line to Excel scatter chart, this is what you need to do: Our line will be dynamic and will react to any data changes automatically. Naturally, we are not going to "tie" a line to the x-axis because we don't want to reposition it every time the source data changes. To highlight an important data point in a scatter chart and clearly define its position on the x-axis (or both x and y axes), you can create a vertical line for that specific data point like shown below: Insert vertical line in Excel bar chart.
![add on office mix add on office mix](https://s3.amazonaws.com/interactive.3playmedia.com/support/image-repository/powerpoint/officeMixRibbon.jpg)
![add on office mix add on office mix](https://www.free-power-point-templates.com/articles/wp-content/uploads/2014/06/download-office-mix-add-in.jpg)