+ Reply to Thread
Results 1 to 2 of 2

Secondary Axis, X-axis spacing (time units)

  1. #1
    Forum Contributor
    Join Date
    09-23-2008
    Location
    UK
    Posts
    137

    Secondary Axis, X-axis spacing (time units)

    Hi,

    This might be easier to follow if you take a look at the attached jpg. Basically I have a plot which uses a secondary axis. I want the data to fill out the x-axis and leave no spacing. The fact that the units are time might complicate things a little. By right-clicking on the axis and manually entering the scale (e.g. 0.357638888888889 for the left limit) I can get the line chart to fit as I want (see the right hand side for the black and red lines). However the secondary data doesn't follow on and a gap remains (see the blue area).

    Any ideas?

    Thanks,
    Martin
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    Try double click the x axis and on the scale tab unselect Crosses Between Categories or maybe Crosses between dates, depends on the axis type.

    If not the post example workbook
    Cheers
    Andy
    www.andypope.info

+ 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