Vertical Bar Chart Excel. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. See screen shot below.
Select bar and press Ctrl 1 which will open up the Format Data Series option to the right of the chart. Click on the Change Chart Type Button. Go to the chart and right click its axis labels you will rotate and select the Format Axis from the context menu.
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. In the end click OK. In a stacked bar chart parts of the data are adjacent in the case of horizontal bars or stacked in the case of vertical bars aka columns. How to Rotate Horizontal Bar Charts into Vertical Column Charts and Vice Versa There are just a few steps involved.
