realitygaq.blogg.se

If you found the website and tutorials helpful, please consider donating to keep the lights on. Therefore, set up the following data in these cells as you see here: So create a new chart data range for a vertical line. We want the vertical line between the 2 regions we have (i.e South Carolina & New York). To make the vertical line, first, we must create data for an XY Scatter graph. The chart will look like this in Excel 2016 (notice that the default is a Chart Title on Top of the Chart and the Legend at the bottom of the chart): Create Vertical Line Between Columns with Error Bars Initial Chart 2) Create the XY Series Data

Then highlight the range A1:D7 and click on the Insert Ribbon and Select Stacked Column Chart: Insert Stacked Column Chart If your chart data is set up in these cells and format: 4) Move the Added Series to Secondary Axis and Change Added Series to XY Chart TypeĦ) Add Error Bars to the XY Chart Series and Format Error Barsħ) Change Secondary Vertical Axis SettingsĨ) Delete Legend Entry Step-by-Step 1) Create a Stacked Column Chartįirst, we need to create a stacked column chart type and this will help understand where the vertical line will be placed.