+ Reply to Thread
Results 1 to 2 of 2

Making Histogram X-axis smaller

  1. #1
    Registered User
    Join Date
    01-14-2021
    Location
    Glasgow
    MS-Off Ver
    2013
    Posts
    1

    Making Histogram X-axis smaller

    Hello,

    I am currently completing research for a dissertation and I have several histograms and I want them to all have the same start and end values on the X-axis for easy comparison but I can't find how to edit the start and finish values on the x-axis.

    I've tried to right click the axis and selecting 'format axis' but this this doesn't have an option for changing the start and end values like bar charts do.

    Any help would be appreciated.

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

    Re: Making Histogram X-axis smaller

    An example might help. I assume that your histograms are column charts, which uses a category/text axis, so Excel assigns no numeric meaning to the horizontal axis. What Excel uses for categories in a column chart is determined by the categories present in the horizontal x axis category range in the spreadsheet. If I wanted several column charts to all have the same categories, I would make sure that the categories (bin values in a histogram) are the same for all charts.

    Can you help us understand how you are creating these histograms? How are you currently choosing your bin values? Would you be allowed to choose the same bin values for each histogram?
    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. Help with making formula smaller
    By AvidanR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2019, 11:08 AM
  2. Need help making histogram
    By achelp in forum Excel General
    Replies: 10
    Last Post: 09-07-2018, 03:21 PM
  3. help with making vba code smaller
    By vendetta907 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2016, 03:57 PM
  4. Replies: 4
    Last Post: 07-31-2015, 12:54 AM
  5. Need help making a histogram
    By Spookycolt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-03-2014, 01:23 PM
  6. Making this code smaller
    By roberto1111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2009, 03:38 PM
  7. Replies: 0
    Last Post: 06-13-2007, 09:41 AM

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