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 ...

How to add a single vertical bar to a ... Be sure to right-click the orange bar and not the line chart. In the Format Data Series pane, click Secondary Axis and change the Gap Width to 500% ...