I want to add a third (tertiary) Y axis to my cart, but don't know how to.

I have seen many references to 
http://peltiertech.com/Excel/Charts/TertiaryAxis.html which apparently used 
to show how to do this, but now doesn't, instead this now extoles the 
virtues of other ways of showing the same thing.  Despite the arguments 
against I want to add a 3rd Y axis to my chart.  All 3 Y Axes will the same 
scale and units, which I think overcomes some of the arguments against using 
multiple axis.

Can anyone tell me or point me at a resource that tells me how to add a 3rd 
Y axis to an existing MS Excel 2007 chart?

TIA.

Chris. 

Hi,

Take a look at the technique Jon uses to create Panel charts with 
different scales.
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

Cheers
Andy

On 11/02/2010 06:17, Chris Mitchell wrote:
> I want to add a third (tertiary) Y axis to my cart, but don't know how to.
>
> I have seen many references to
> http://peltiertech.com/Excel/Charts/TertiaryAxis.html which apparently used
> to show how to do this, but now doesn't, instead this now extoles the
> virtues of other ways of showing the same thing.  Despite the arguments
> against I want to add a 3rd Y axis to my chart.  All 3 Y Axes will the same
> scale and units, which I think overcomes some of the arguments against using
> multiple axis.
>
> Can anyone tell me or point me at a resource that tells me how to add a 3rd
> Y axis to an existing MS Excel 2007 chart?
>
> TIA.
>
> Chris.
>
>

Andy.

As I said I have seen Jon's pages, but despite his well reasoned arguments I 
would like to add a 3rd axis.

I'm sure I saw this in Excel at one point but I didn't need it then, so I 
didn't make a note of it.

How can I add a 3rd axis to my MS Excel 2007 chart?

Note, unlike Jon's panel chart all 3 axis will share a common units and 
scale.

"Andy Pope" <andy@andypope.info> wrote in message 
news:ukDuRnwqKHA.4604@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> Take a look at the technique Jon uses to create Panel charts with 
> different scales.
> http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html
>
> Cheers
> Andy
>
> On 11/02/2010 06:17, Chris Mitchell wrote:
>> I want to add a third (tertiary) Y axis to my cart, but don't know how 
>> to.
>>
>> I have seen many references to
>> http://peltiertech.com/Excel/Charts/TertiaryAxis.html which apparently 
>> used
>> to show how to do this, but now doesn't, instead this now extoles the
>> virtues of other ways of showing the same thing.  Despite the arguments
>> against I want to add a 3rd Y axis to my chart.  All 3 Y Axes will the 
>> same
>> scale and units, which I think overcomes some of the arguments against 
>> using
>> multiple axis.
>>
>> Can anyone tell me or point me at a resource that tells me how to add a 
>> 3rd
>> Y axis to an existing MS Excel 2007 chart?
>>
>> TIA.
>>
>> Chris.
>>
>> 

As I said the technique Jon used to have published is exactly the same 
technique used to create dummy axis on the panel charts.

You have to use a dummy series to draw the line and data labels to 
provide the labeling of the axis.

Cheers
Andy

On 11/02/2010 17:01, Chris Mitchell wrote:
> Andy.
>
> As I said I have seen Jon's pages, but despite his well reasoned arguments I
> would like to add a 3rd axis.
>
> I'm sure I saw this in Excel at one point but I didn't need it then, so I
> didn't make a note of it.
>
> How can I add a 3rd axis to my MS Excel 2007 chart?
>
> Note, unlike Jon's panel chart all 3 axis will share a common units and
> scale.
>
> "Andy Pope"<andy@andypope.info>  wrote in message
> news:ukDuRnwqKHA.4604@TK2MSFTNGP05.phx.gbl...
>> Hi,
>>
>> Take a look at the technique Jon uses to create Panel charts with
>> different scales.
>> http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html
>>
>> Cheers
>> Andy
>>
>> On 11/02/2010 06:17, Chris Mitchell wrote:
>>> I want to add a third (tertiary) Y axis to my cart, but don't know how
>>> to.
>>>
>>> I have seen many references to
>>> http://peltiertech.com/Excel/Charts/TertiaryAxis.html which apparently
>>> used
>>> to show how to do this, but now doesn't, instead this now extoles the
>>> virtues of other ways of showing the same thing.  Despite the arguments
>>> against I want to add a 3rd Y axis to my chart.  All 3 Y Axes will the
>>> same
>>> scale and units, which I think overcomes some of the arguments against
>>> using
>>> multiple axis.
>>>
>>> Can anyone tell me or point me at a resource that tells me how to add a
>>> 3rd
>>> Y axis to an existing MS Excel 2007 chart?
>>>
>>> TIA.
>>>
>>> Chris.
>>>
>>>
>
>

-- 

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