Vertical Bar Chart Excel. Glossy Gantt Chart With A Vertical Line Microsoft Excel 2016. In some empty cells set up the data for the vertical line like shown below.
Right click a column in the chart and select Format Data Series in. Insert Column or Bar chart. When you create a chart Microsoft Office Excel determines the axis on which the data series are plotted based on the number of worksheet rows and columns that are included in the chart placing the larger number on the horizontal axis.
After that go to your data table and insert following formulas to the cell C2 Formula Bar and drag down up to the last cell of the table.
In the end click OK. Glossy Gantt Chart With A Vertical Line Microsoft Excel 2016. Link your scroll bar to cell C10 and enter 12 for maximum value. To add a new data series to your chart do one of the following.
