A date-and-cost line chart tracks a commodity's changing price over time. ... As with all charts that record periodic changes, time, the independent variable must go on the chart's x-axis.

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

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.

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

Bar charts and line graphs can be combined. Climate graphs are an example of this. The x-axis shows the months of the year and there are two y-axes to show average temperature and total rainfall.