Two vertical axes in one chart

**a.janmohammadi** · 12-30-2013, 07:18 AM

Hi everyone.
How can insert a chart with two vertical axes, one showing for example a person's monthly income, the other a person's cumulative monthly income?
Thx in advance

**TMS** · 12-30-2013, 07:35 AM

http://www.techonthenet.com/excel/charts/2_y_axes.php

Regards, TMS

**Sam Capricci** · 12-30-2013, 08:16 AM

When you are in the chart click, if both sets of data are shown and appear along the horizontal axis, double click on one set of the data along that axis and a box should appear >> format data series >> and under series options you can click secondary axis and that should do it for you. After that just double click on either axis and you can format it by numbers and add titles etc.