Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc
Dmitry
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc
Jon Peltier
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you link primary and secondary axis zero, scaling? CarolM Charts and Charting in Excel 3 April 24th 06 01:30 AM
how can I have a secondary axis bar not covering the primary axis Luiz C Bigas Charts and Charting in Excel 1 April 5th 06 05:57 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Changing Secondary axis value units sherobot Charts and Charting in Excel 4 May 2nd 05 07:00 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"