Share via

excel 2010: controlling the date sequence on the horizontal axis of a bar chart to show 1st and 15th date of each month

Anonymous
2012-05-29T18:23:26+00:00

I tried to control how the beginning date and date increments are displayed on the bar chart horizontal axis to show the 1st and 15th day of each month, however, the controls i use are not correct. Please help me understand how to do it.

Here's what i did:

  1. created a table that looks like this:

project          due date

A                   June 15, 2012

B                  sept 1, 2012

C                  dec 15, 2012

Under the "Layout" tab> "axis" > "primary horizontal axis">"more options",  i set minimum to 41061 to start the date sequence at June 1.  I set the "major unit" to 15.

As is quickly evident, because the months vary from 30 to 31 days, a major unit of "15" will quickly cause the legend to display every 15 day interval.

How do i set the axis to show the 1st and 15th date of every month?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-06-13T04:40:48+00:00

    The units for an access in Excel chart has to be a whole number, so the best option would be to use 1 month as Major unit and 15 days as Minor unit.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2012-05-30T18:26:26+00:00

    Ashish,

    Thank you for your reply. That is a good tip to know, HOWEVER --

    Actually, I probably should not have used 1st and 15th in my example because the actual dates could be any date.

    What I want to show in the horizontal axis is the 1st and 15th of each month (June 1, 2012, June 15, 2012, July 1, 2012) for all the months in the table date range.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2012-05-29T23:54:22+00:00

    Hi,

    If you wish to show the dates as are in your source data, try this

    1. Select the x axis dates and right click > Format Axis
    2. Under Axis type, select Text axis

    Hope this helps.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2012-05-31T17:11:35+00:00

    Ashish,

    Thank you for your interest. I am not aware as to where I can upload a file. Do you know where I can upload a file?

    Maybe I can explain it better. I want the major vertical grid lines on horizontal axis to show the 1st and 15 of the month from the beginning to the end of the date range in the table (01-Jun, 15-Jun, 01-Jul, 15-Jul, etc.). 

    For each project (along the far left vertical axis), there would be a horizontal bar that extends out to the due date. For example, for a project due on 07-Jul, the bar would extend out and end between the 01-Jul and 15-Jul gridlines.

    Was this answer helpful?

    0 comments
  5. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2012-05-30T22:53:33+00:00

    Hi,

    i am not sure whether i understnd thq question.  Could you kinldy uppoad the file and provide a link please.

    Was this answer helpful?

    0 comments