How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. ... make it a line graph instead of a bar graph). With the series selected, click the Design tab, ...

The most useful selection is a bar chart, because it allows you to format the second series as a line. Superimposing two types of charts makes identifying the two data scales easier. More For You ...

How to create a Line Chart in Excel. To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12).

The next step is to make the vertical bar extend beyond the $1,800,000 on the left by changing the secondary axis to its maximum boundary, which is 1,800,000. Doing so will extend the vertical bar.

Learn how to plot coordinates and create straight line graphs to show the relationship between two variables. Also, plot graphs that contain a negative coefficient of x.

To create a line graph: Look for the largest frequency in your table. Draw a vertical axis close vertical axis The line on a graph that runs vertically (up-down) from the origin.