How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
 

Hello specialists!
How to place a secondary y axis bar in a bar chart next to, not over, two
primary y axis bars?
Best regards,
Dima

How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
 

The only way I can think of is to make a new chart with the third y
axis, make it the same height as the original chart but slightly wider,
then set fill = transparent, then sit the transparent chart on top of
your original chart. Similar principles to making a speedometer chart.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=538344

How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
 

The only way I can think of is to make a new chart with the third y
axis, make it the same height as the original chart but slightly wider,
then set fill = transparent, then sit the transparent chart on top of
your original chart. Similar principles to making a speedometer chart.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=538344

How to place a secondary y axis bar in a bar chart next to two primary y axis bars?
 

Is this what you want?

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

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

"Dmitry" wrote in message
...
Hello specialists!
How to place a secondary y axis bar in a bar chart next to, not over, two
primary y axis bars?
Best regards,
Dima