ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating a clustered column chart (https://www.excelbanter.com/charts-charting-excel/212531-creating-clustered-column-chart.html)

Lauren

Creating a clustered column chart
 
I need to create a bar-bar graph with a secondary axis. When I try to add
the second axis, it puts the two bar graphs on top of each other like a
stacked column graph. I need two distinct bar graphs with 2 differ vertical
axes. How can I do this? Thanks.

Jon Peltier

Creating a clustered column chart
 
Try this:

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

Unfortunately it's difficult to avoid confusion between the axes, for the
people looking at your chart.

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


"lauren" wrote in message
...
I need to create a bar-bar graph with a secondary axis. When I try to add
the second axis, it puts the two bar graphs on top of each other like a
stacked column graph. I need two distinct bar graphs with 2 differ
vertical
axes. How can I do this? Thanks.





All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com