View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do I set up secondary axis on bar graph. What do I highlight?

Fair comment. I think I will add a tip on creating a secondary Y axis
and make reference to that in the secondary X axis tip.

Cheers
Andy

Jon Peltier wrote:
Sure, the example has two series, but it doesn't explicitly mention that two
series is the minimum requirement for two axes. Also, the original post
reminded me of so many that ask for a second axis without realizing a second
series is needed.

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


"Andy Pope" wrote in message
...

Hi Jon,

Not sure I understand. The example is a two series chart and the
instructions say use the second series.

Cheers
Andy

Jon Peltier wrote:

Andy -

You should note at the top of your page (tip008.htm) that you need a
second series before you can have a secondary axis. This is a common
misunderstanding.

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


"Andy Pope" wrote in message
...


Hi,

This explains how to display the secondary axes.
http://www.andypope.info/tips/tip008.htm

Cheers
Andy

inquiringmind73 wrote:


I am having trouble adding a secondary axis to a bar graph. Can you
help? What do I highlight? please walk me through this .thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info