how do i create a bar chart that has 2 y axis instead of one?

[Conchubar]

Hi when using the chart wizard on excel i see you can create a "lines on 2
axis" (2 y axis) graph. All i want to do is create a graph with "bars on 2
axis." Please help me! many thanks

 

[Jon Peltier]

You don't need to use Excel's built-in custom types; you can design your
own types. In general you can select a series and change its type using
Chart Type on the Chart menu. You can double click on the series, and on
the Axis tab, choose Primary or Secondary.

For a column chart that uses primary and secondary axes, changing one to
Secondary causes it to overlap the primary series. You need to use some
blank series as spacers to prevent this overlap, as described in this
example:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______