+ Reply to Thread
Results 1 to 6 of 6

Adjust interval between tick marks in a graph

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Ridderkerk, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    3

    Adjust interval between tick marks in a graph

    It is impossible to adjust the interval between tick marks when displaying an horizontal axis with 2 categories (years and weeks). The following steps do not change the space between the tick marks.
    • Select the graph;
    • Chart Tools – Lay Out;
    • Current selection – Horizontal (Category) Axis;
    • Format selection;
    • Axis options;
    • Interval between tick marks: 4.
    How can I change the interval for the tick marks to display a mark after every four weeks? Is this a bug or by design?

    Thanks in advance.
    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,434

    Re: Adjust interval between tick marks in a graph

    MS would probalby say by design.

    One work around is to use secondary axis to provide the tick marks.
    In the attached I did 12 months rather than 52 weeks for previty.

    add secondary horizontal axis and format as required.
    The format secondary vertical axis to cross as zero
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-06-2014
    Location
    Ridderkerk, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adjust interval between tick marks in a graph

    Thanks, this solution worked for me.
    The excellent attachment really helped.

  4. #4
    Registered User
    Join Date
    02-15-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adjust interval between tick marks in a graph

    I want more number of minor tick intervals on x axis, in case of percentage variation and not in date format.
    So please help me for the same.

  5. #5
    Registered User
    Join Date
    02-15-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adjust interval between tick marks in a graph

    I want more number of minor tick intervals on X axis. How can i do this.
    Attached Files Attached Files

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

    Re: Adjust interval between tick marks in a graph

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.


    Use xy-scatter rather than Line chart

+ 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. Replies: 0
    Last Post: 03-22-2012, 09:46 AM
  2. Adjust tick marks to first day of month
    By maacmaac in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-01-2010, 10:37 AM
  3. [SOLVED] Offsetting tick marks of a line graph
    By Dial1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-11-2010, 09:45 AM
  4. inserting tick marks/hash marks
    By psuexv in forum Excel General
    Replies: 6
    Last Post: 09-25-2007, 03:58 PM
  5. Tick marks
    By ofey in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-21-2005, 02:35 PM

Tags for this Thread

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