+ Reply to Thread
Results 1 to 2 of 2

Increments for days/months on y-axis

  1. #1
    Registered User
    Join Date
    06-27-2018
    Location
    Paris, France
    MS-Off Ver
    Excel, 2016
    Posts
    30

    Question Increments for days/months on y-axis

    Hello all,

    This is gonna sound noobish, but I'd like some advise on how to set up days and months on the y-axis such that they are in increments. The obvious problem is that some months do not have exactly 30 days. So Excel, from what I've seen so far, will throw a random number of days. I just want it so that it shows 31 days for Jan, 28 days for Feb, 31 days for March, 30 for April etc. but show these as fixed, one month increments. Is it possible to have Excel show the months in increments?

    Thank you in advance!

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Increments for days/months on y-axis

    If I understand your goal, then changing the axis to 'text' may help. Note that Excel will then put the dates as you have them in your table. For something that is not trying to graph the change across time, this should work. You can 'adjust' your data to only show first of the month (or the 15th or the end of the month or whatever you want).

    While not your specific issue, this link shows the process:
    https://www.nhaustralia.com.au/blog/...el-chart-axis/
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ 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: 8
    Last Post: 06-12-2015, 04:23 PM
  2. Defining Increments of Y-Axis in a graphic
    By SkillzFlux in forum Excel General
    Replies: 0
    Last Post: 01-11-2012, 03:39 PM
  3. Uneven increments on X-Axis
    By jfarlow in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-13-2008, 10:13 AM
  4. [SOLVED] How do I get the category axis units to be in even increments?
    By Nicocala in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-01-2006, 04:45 PM
  5. [SOLVED] How do I set my X axis to include equal increments of a day?
    By Dianne in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-09-2005, 07:05 PM
  6. [SOLVED] How can i draw a graph with days and months in the primary axis
    By Sumeet Chopra in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2005, 09:05 AM
  7. Excel has created Y-axis increments of .14!
    By arhooley in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-13-2005, 08:06 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