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.
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.
#Scatter chart excel y axis 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:
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 vertical line to Excel scatter chart.We will just have to do a little lateral thinking! However, "no easy way" does not mean no way at all. But there is still no easy way to draw a vertical line in Excel graph. In the modern versions of Excel 2013, Excel 2016 and Excel 2019, you can add a horizontal line to a chart with a few clicks, whether it's an average line, target line, benchmark, baseline or whatever.
You will also learn how to make a vertical line interactive with a scroll bar. The x-axes are not aligned because they are not the same data or even the same type of data!Īll that said, if you change both series to XY Scatter, it is possible (with some extraordinary effort) to apply shading/coloring below a series or between two series, etc.The tutorial shows how to insert vertical line in Excel chart including a scatter plot, bar chart and line graph. So even though the two series appear to share the same set of X-Values, the Chart is simply incapable of treating those as the same type of data. The problem I have is that the x-axis values of the two series are not aligned. But in your Area chart, it treats the X-values as categorical, and in this context "1.1" is no different than "Bob" - it is a cardinal representation of the data rather than an ordinal representation. I.e., in the Scatter series, the data is X/Y pairs. Without making any changes to the axes configuration, the second X-axis will now appear along the bottom of the chart, and you can see it is scaled differently from your Scatter data. You can verify this by selecting Chart > Layout > Axes > Secondary Horizontal Axis > More Secondary Horizontal Axis Options. So, Excel doesn't know how to plot your categories (columns) on an interval scale (the current X axis). The short answer is that your combining (unsuccessfully) a categorical series (the columns) with interval/ratio series (the line charts). The problem is summarized in this similar Q on SuperUser: There may be another way to do this while retaining the Scatterplot, I'm not sure, but this seems to be visually what you're looking for, but I think you will need to use a Line Chart for this unfortunately. Change the Scatter to a Line Chart, then format Line Color so that there is "No Line".