I have been trying to change the dates TO START FROM 2021 rather than 2016 on axis title in a timetable ( gannt chart) and also add an additional row to the data displayed titled "genetics" but its not working when I edit the data.
I have been trying to change the dates TO START FROM 2021 rather than 2016 on axis title in a timetable ( gannt chart) and also add an additional row to the data displayed titled "genetics" but its not working when I edit the data.
Click on the chart area then hover over the date axis and right-click then click on Format Axis. Then in the Minimum box you should enter 44197, which is the serial number for 1st January 2021. Click on the chart area again and it should change to make 1/01/2021 the starting value.
Insert a new row 13, then copy/paste the values from rows 14 and 15 into row 13, then delete row 15.
Hope this helps.
Pete
EDIT: File attached
Last edited by Pete_UK; 07-26-2021 at 07:51 AM.
Thanks a lot Pete! Just one more thing, how do i shift the genetics to be before analysis of results rather than at the end please? Thanks a lot!
Dont worry, I have sorted it. It was simple. Thanks a lot once again!
Glad to help.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.
You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks