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.

This article explains how to add a secondary axis to a chart in Excel so you can view unlike categories on the same graph. These instructions work in Excel in Microsoft 365, Excel 2021, Excel 2019 ...

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.

Howdy Folks,I have an Excel spreadsheet with several charts in it. Each chart has several data series plotted as xy scatter. I would like to change the marker size for each data series using VBA ...