+ Reply to Thread
Results 1 to 2 of 2

Histogram - Indication at Tick Marks

  1. #1
    Registered User
    Join Date
    04-07-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Histogram - Indication at Tick Marks

    Hi

    How can I get the Bin below to indicate at the tick marks instead at the middle of interval?

    I enclosed sample file.

    Thank you

    Bin Frequency
    20000 18
    25000 38
    30000 18
    35000 4
    40000 2
    45000 0
    Attached Files Attached Files

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

    Re: Histogram - Indication at Tick Marks

    If I understand what you are asking for, you should be able to go into the "format axis" dialog for the horizontal axis (https://support.office.com/en-us/art...rs=en-US&ad=US ) and, at the bottom of the dialog, should be an option to "position axis" "on tick marks" or "between tick marks". Select the desired option, to get the axis labels to show up underneath or between tick marks.

    If that does not do what you want, you might look at Jon Peltier's site. He has several tutorials for different axis tricks (usually using a column/scatter combination chart). http://peltiertech.com/Excel/Charts/axes.html
    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. inserting tick marks/hash marks
    By psuexv in forum Excel General
    Replies: 6
    Last Post: 09-25-2007, 03:58 PM
  2. Tick marks
    By ofey in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-21-2005, 02:35 PM
  3. Placement of tick marks
    By J. McAdams in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2005, 04:05 AM
  4. [SOLVED] Green Tick Marks
    By DNA in forum Excel General
    Replies: 5
    Last Post: 06-13-2005, 04:05 PM
  5. Displaying specific tick marks
    By faswad in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-10-2005, 03:25 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