+ Reply to Thread
Results 1 to 3 of 3

Secondary Horizontal Axis Wider than Primary Horizontal Axis

  1. #1
    Registered User
    Join Date
    10-31-2010
    Location
    London
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    56

    Secondary Horizontal Axis Wider than Primary Horizontal Axis

    Hi,

    I am using excel 2010 and on a chart have two horizontal date axes, one primary one secondary. Now the problem I am having is that although the settings on both the axes are exactly the same including the Max and Min values etc the secondary horizontal axis is two notches wider than the primary horizontal axis creating white space on both sides of the chart. I have also attached a jpeg showing the same.

    Any ideas what could be causing this?

    Thanks
    Attached Images Attached Images
    Last edited by goels; 03-11-2011 at 09:02 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Secondary Horizontal Axis Wider than Primary Horizontal Axis

    The Line series is defaulting the axis to have a Position between tickmarks.
    Area charts normally have a position on tickmarks.

    Simply format each axis to be positioned on tickmarks.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-31-2010
    Location
    London
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    56

    Re: Secondary Horizontal Axis Wider than Primary Horizontal Axis

    Hi Andy,

    Thanks - just realised that myself

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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