How to add a vertical line to a chartĪ vertical line on a bar chart would be just as useful as a horizontal line on a column chart. Charting in Excel is very easy and you īack to top 2. There are only two columns in the second series because of the two cells we selected as series values.Ĭharts in Microsoft Excel lets you visualize, analyze and explain data. Select cell range B10:B11 for series values.Įxcel colored the second series differently so you can distinguish them easily.Press with left mouse button on "Add" button.Press with right mouse button on on the chart.This series will be the horizontal line on the y-axis value 140. I will now add more data, see cell range A9:B11 in the picture below. The Excel column chart is created, shown in the picture below. Press with left mouse button on the "Column chart" button.You can see my data in cell range A1:B7, see picture below. The first step is to create a chart with only one series. Create a straight line through first and last chart column.Change the chart type of the second series.How to add a vertical line to an Excel Chart.
0 kommentar(er)
