How do I set up secondary axis on bar graph. What do I highlight?

[inquiringmind73]

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]

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

[Jon Peltier]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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

[Jon Peltier]

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" <[email protected]> wrote in message
news:%239N$6%[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>>
>>>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]

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" <[email protected]> wrote in message
> news:%239N$6%[email protected]...
>
>>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" <[email protected]> wrote in message
>>>news:[email protected]...
>>>
>>>
>>>>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