Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis shows the values for the associated data series. A secondary axis works well in a chart that shows a combination of column and line charts.
Please see the following sample code that creates a new Excel file and puts the chart data in the first worksheet.
Then we add a chart and display the secondary axis.

The following sample code generates the output Excel file.
Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.