Two different y-axis scales?
 

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!

Two different y-axis scales?
 

"Chris" wrote in message
...
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.
--
David Biddulph

Two different y-axis scales?
 

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/...OnTwoAxes.html

Cheers
Andy

Chris wrote:
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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Two different y-axis scales?
 

Thanks!

Chris

"Andy Pope" wrote:

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/...OnTwoAxes.html

Cheers
Andy

Chris wrote:
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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info