Using two axes in one chart
For example, if you have two too different data (e.g., sales in Unit A and in Unit B), 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. Right-click in the second (Unit B) data series, in the popup menu select Change Series Chart Type...:
3. In the Change Chart Type dialog box, in the Combo group of charts, choose secondary axis for second data series:
Change other parameters for the secondary axis.
How to add next data series with another axis, see Combining several charts into one chart.