When the values in a chart vary widely from
data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.
to data series, you can plot one or more data series on a secondary axis. A secondary axis can also be used as part of a combination chart when you have mixed types of data (for example, price and volume) in the same chart.
In this chart, the primary vertical axis on the left is used for sales volumes, whereas the secondary vertical axis on the right side is for price figures.
Do any of the following:
Add a secondary axis
Add an axis title for a secondary axis
Add an axis label for a secondary axis