• 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

    Hui...

  • 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?

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!
Carlos
 
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.
 
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
 
Back
Top