+ Reply to Thread
Results 1 to 3 of 3

Change Chart Axis Labels to 1st of Each Month

  1. #1
    Registered User
    Join Date
    03-15-2019
    Location
    Sacramento, CA
    MS-Off Ver
    2016 Professional Plus
    Posts
    2

    Change Chart Axis Labels to 1st of Each Month

    I currently have a chart with the horizontal axis being dates from 1/1/18 - 1/1/19, but I need each date and corresponding section to be the first of each month. I checked out the Office Excel help page titled: Display or change dates on a category axis, but it doesn't work for my version of Excel (I don't have the Base option under units nor the date options in units).

    Unfortunately, this is my first post so I can't give you any images or links.


    Thanks in advance!
    Attached Images Attached Images

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

    Re: Change Chart Axis Labels to 1st of Each Month

    Based on those pictures it looks like you are using an XY scatter chart, which does not have the same "category/date axis" options like you saw described in the help file. In order to get those options, you need to change your chart type to line and make sure that Excel designates the horizontal axis as a "date axis". Then you should have the options to set base unit as month and so on.

    These essays are fairly old (still referencing Excel 2003), so some of the dialogs are different, but the basic principles between horizontal value axis, date axis, or category axis should still apply:
    https://peltiertech.com/line-charts-vs-xy-charts/
    https://peltiertech.com/Excel/Charts...ValueAxis.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-15-2019
    Location
    Sacramento, CA
    MS-Off Ver
    2016 Professional Plus
    Posts
    2

    Re: Change Chart Axis Labels to 1st of Each Month

    Worked - Thanks a bunch!

+ 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. Have chart auto change depending on axis labels
    By scorpain in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-30-2018, 04:29 AM
  2. Changing chart type & second axis on chart with 2-level axis labels
    By trolle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2016, 09:52 AM
  3. Change X-axis labels on pivot chart?
    By Matteo2000 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-18-2014, 04:15 AM
  4. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  5. End of Month Chart Axis Labels
    By djt76010 in forum Excel General
    Replies: 8
    Last Post: 10-18-2012, 05:53 AM
  6. Replies: 1
    Last Post: 06-26-2012, 10:02 AM
  7. Replies: 1
    Last Post: 12-02-2005, 03:20 AM

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