1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cumulative data chart - How to change time increments?

Discussion in 'Discuss Data Visualizations and Charting' started by Carlos Ruano, Apr 21, 2017.

  1. Carlos Ruano

    Carlos Ruano Member

    I successfully created a cumulative graph based on hours entered in time sheets by a particular role of employee. My problem is that the dates for time entry are daily, and the project has been running for a long time. This makes the graph impossible to read. Is there a way to change the time increment to monthly instead of daily? Or is there some other solution that might help?

    Thank you!
  2. Luke M

    Luke M Excel Ninja

    upload_2017-4-21_15-21-12.png Guessing at layout, you should be able to right-click on the x-axis and format. Make sure it's using a "Date axis" not a "Text axis". Then you can change the Base unit to be Months instead of days.
    Siga likes this.
  3. Hui

    Hui Excel Ninja Staff Member

    You could also
    Change the Major Unit above to Fixed and set the interval to 1, 2 or more months
    Leave the Base unit as days

Share This Page