+ Reply to Thread
Results 1 to 3 of 3

Fixed number of Y-axis labels - possible?

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    15

    Fixed number of Y-axis labels - possible?

    The trick is, the graph is working off a dynamic input range, so the data always changes.
    It's just a bar graph, with a time series on the X-axis.
    I'm using Excel 2010 set to format the Y-axis labels as fully "Auto", which makes sense, as the graph changes size depending on the input range selected.
    Using this auto setting, sometimes the graph will have 6 data labels on the Y-axis, sometimes 8.

    Is there a way to let Excel continue to set the minimum and maximum points itself, but force it to always show me, say, ten y-axis labels?
    I'm suspecting not, but does anyone know for sure?

    regards,
    Graeme

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

    Re: Fixed number of Y-axis labels - possible?

    You would need to alter the Major Unit value. This would require VBA coding
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Fixed number of Y-axis labels - possible?

    Thought it might be something like that.
    Not for me, I'm afraid.
    Thanks anyway,
    Graeme

+ 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. Charts: Format Axis -> Axis Options -> Fixed minimum and maximum
    By johnmata in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-28-2013, 05:53 PM
  2. Replies: 0
    Last Post: 12-08-2007, 06:14 PM
  3. Reducing the number of x axis labels
    By spog in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-29-2006, 05:00 AM
  4. [SOLVED] Number of labels on X-axis one more than number of values on Y-axi
    By Gudrun in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-26-2005, 09:05 AM
  5. [SOLVED] [SOLVED] Least number of digits in Y-axis labels
    By Charley Kyd in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 02-06-2005, 12:06 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