how do i create a bar chart that has 2 y axis instead of one?
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 |
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/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Conchubar wrote: 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 |
All times are GMT +1. The time now is 05:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com