+ Reply to Thread
Results 1 to 2 of 2

How to add Secondary Horizontal Axis With Custom Titles

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    U.S.
    MS-Off Ver
    2013
    Posts
    66

    How to add Secondary Horizontal Axis With Custom Titles

    I really need to adda secondary horizontal axis, to the top of my chart. I have been just inserting a text box, but this is very inefficient. I figured out how to add a secondary axis and get it up there to the top, but it is only numbered, it will not let me add custom text to the axis with a scatter chart. Any ideas?
    Last edited by comp; 10-17-2015 at 09:39 PM.

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

    Re: How to add Secondary Horizontal Axis With Custom Titles

    It is difficult to tell from a picture just what you are trying. I would expect something like the arbitrary axis technique (see this for a vertical example. http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html it should be easy to adapt to your horizontal axis) would work for you.

    I could see something that simply uses a line/scatter combination chart (the series on the secondary axis system would be the line chart) could also be made to work (see this tutorial http://peltiertech.com/Excel/Charts/ChartIndex.html#C ). The main challenge here is formatting the data and axis so that the line's category axis matches up with the XY scatter's value axis.
    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. [SOLVED] Secondary horizontal axis problem
    By silkpantsman in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-23-2015, 06:44 AM
  2. Replies: 2
    Last Post: 04-15-2015, 01:10 AM
  3. How to add secondary horizontal (category) axis in a chart?
    By S K ROY in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-09-2012, 07:13 AM
  4. Log horizontal axis with secondary virtical
    By jqavins in forum Excel General
    Replies: 5
    Last Post: 09-29-2011, 10:25 AM
  5. Formatting Horizontal Axis Titles
    By lindsayboxer in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-30-2011, 05:31 AM
  6. Replies: 2
    Last Post: 03-11-2011, 09:02 AM
  7. Replies: 6
    Last Post: 12-07-2010, 02:54 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