ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel bar graph with two axes (https://www.excelbanter.com/charts-charting-excel/67900-excel-bar-graph-two-axes.html)

Ben-Head

Excel bar graph with two axes
 
I'm trying to set up a chart with four series on two Y-axes (two series on
each). I can do that, but I get the two series of one axis superimposed over
the two series of the other axis. Is there a way to have all four bars
display next to each other (the way they do if it's just one axis) but scaled
to the two axes?

Barb Reinhardt

Excel bar graph with two axes
 
I'm guessing you want something like this

http://www.peltiertech.com/Excel/Cha...OnTwoAxes.html


"Ben-Head" wrote in message
...
I'm trying to set up a chart with four series on two Y-axes (two series on
each). I can do that, but I get the two series of one axis superimposed
over
the two series of the other axis. Is there a way to have all four bars
display next to each other (the way they do if it's just one axis) but
scaled
to the two axes?





All times are GMT +1. The time now is 05:42 PM.

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