+ Reply to Thread
Results 1 to 2 of 2

How can I add tertiary Y axis in my excel 2010

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    1

    How can I add tertiary Y axis in my excel 2010

    Can anybody please help me in plotting the tertiary Y axis. I have a excel sheet where I have to represent bar chart with labelling primary Y axis and a line chart with labelling secondary Y axis. Now I need to add another Line chart with tertiary Y axis , adjacent to Secondary Y axis. I could not able to do that. Please can anybody help me in this regard.
    Thank you for your time and cooperation.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How can I add tertiary Y axis in my excel 2010

    Jon Peltier prefers panel charts to using multiple y axes: http://peltiertech.com/Excel/Charts/TertiaryAxis.html I think his arguments are worth considering.

    You can still add a tertiary y axis by adapting his arbitrary y axis technique http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Instead of using the arbitrary axis to replace the existing axis, you would add it as an additional axis in addition to the other axes.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is there a way to have a smart axis using Excel 2010?
    By emusinger in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2013, 06:19 PM
  2. [SOLVED] Alignment of Secondary X-Axis in Excel 2010
    By Krandamor in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2013, 02:49 PM
  3. Tertiary vertical axis
    By jeb225 in forum Excel General
    Replies: 9
    Last Post: 05-07-2010, 03:41 AM
  4. A Tertiary axis probably????
    By maverick_abhi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2007, 02:19 AM
  5. [SOLVED] How do I add a tertiary Y axis in excel?
    By jdemaioribus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-08-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1