For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis. A simple chart consists of an x-axis and a y-axis, with the x-axis representing the various rows or ...

Select the Y axis values for the second set of data, and then press "Enter." This set of data is labeled as "Series 2." Adding a Series to an Excel Chart. Microsoft Excel 2013 charts are dynamic ...

How to add a single vertical bar to a Microsoft ... In the Format Data Series pane, click Secondary Axis and change the Gap Width to 500%, as shown in Figure G. Doing so reduces the bar’s ...