Using two axes in one chart

For example, if you have two indicators (e.g., volume and price), which you want to see in one chart:

To create one chart for this data, follow these steps:

   1.   Create the chart with that data range:

For example, on the Insert tab, in the Charts group, choose the Column button:

Choose Clustered Column. You can see not informative chart because of too different amounts:

   2.   Excel use primary axis in charts, to change which axis - primary or secondary - can uses for the data series, do the following:

• Right-click in the second (price) data series, in the popup menu select Format Data Series... to open the Format Data Series dialog box:
  
• Choose the Secondary Axis checkbox.

   3.   To change a format type of the second data series, right-click in the second (price) data series and choose Change Series Chart Type...:

You can choose another chart type, for example, a line.

How to add next data series with another axis, see Combining several charts into one chart.