In the Format Data Series pane, click Secondary Axis and change the Gap Width to 500%, as shown in Figure G. Doing so reduces the bar’s width so it looks less like a column and more like a line.

For example, you could show line graphs for temperature and humidity on top of each other. For this purpose, Excel lets you add a series of data to a chart and plot it on a second y-axis.

Launch Excel and load the spreadsheet containing the data you want to plot. Select the first set of X and Y axis data for your chart. Click the "Insert" tab, and then select the chart type and sub ...

The values are plotted across the y-axis and the x-axis is used to mark the progression. In the case of a scatter plot, whether you use it simply with marking points or lines, the graph is spread ...

Bar and line graphs connect the dots with a solid bar or a line. The two graphs, like a dot plot, have both an x- and y-axis.

Line graphs Line graphs show how data changes over time or space. The x-axis shows time or distance. A line graph could be used to show the changes in a country's employment structure over time.

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.