Two different y-axis scales?

[Guest]

Hello,

Is it possible in Excel to have different scales for two sets of data? I
want to show quantities and costs together in a column chart.

Thanks!

 

[David Biddulph]

Hello,

Is it possible in Excel to have different scales for two sets of data? I
want to show quantities and costs together in a column chart.

Yes. Format Data Series/ Axis/ select secondary axis.

 

[Andy Pope]

Hi,

Have a look at Jon's page. With columns it is not just as simple as
changing the axis as columns on the secondary axis will cover those on
the primary.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

Cheers
Andy

 

[Guest]

Thanks!

Chris

Hi,

Have a look at Jon's page. With columns it is not just as simple as
changing the axis as columns on the secondary axis will cover those on
the primary.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

Cheers
Andy