How to make a line graph in Excel 1. Open the Excel spreadsheet with the ... Select the chart style that you prefer from the pop-up window by clicking on it. The chart will automatically be ...

Note how the total adds up to 100%. 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 ...