This formula is inserted in both X cells (D2 and D3). Since we are going to draw a vertical average line, we calculate the X value as the average of cells B2 through B7: In some empty cells, set up the data for the vertical line like shown below.Select your data and make a bar chart ( Insert tab > Charts group > Insert Column or Bar chart > 2-D Bar).To create a vertical line in your Excel chart, please follow these steps: 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: 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.
Set Direction to Both if you'd like the vertical line to go upwards and downwards from the data point.Depending on your needs, set Direction to one of the following: On the Format Error Bars pane, switch to the Error Bar Options tab (the last one) and set Percentage to 100.Right-click on the vertical error bar and choose Format Error Bars… from the context menu.Select the new data point in your chart (orange in our case) and add the Percentage error bars to it ( Chart Elements button > Error Bars > Percentage).Otherwise, the selected x and/or y cell will be added to the existing array, which will lead to an error. Be sure to delete the existing contents of the Series values boxes first - usually a one element array like =.
0 kommentar(er)
