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.

Excel automatically distributes these points along a uniform X axis. To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data.

In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

ADJUST THE AXIS SCALE ON AN EXCEL CHART Excel usually does a good job second-guessing me when it chooses the scale for an axis on a chart. But sometimes, to better focus some data, I need to adjust ...