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.

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.

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.