+ Reply to Thread
Results 1 to 4 of 4

On off duty cycle chart not working for 2022

  1. #1
    Registered User
    Join Date
    12-15-2021
    Location
    Abu Dhabi
    MS-Off Ver
    Office 2013
    Posts
    2

    On off duty cycle chart not working for 2022

    I'm working on a chart of on-off duty cycle for my department employees. The rotation cycle chart is not showing, When I've updated it for year 2022. I've changed all the dates and min, max values as instructed. Still it is not working for 2022. its only showing when the dates are in 2021. please refer the attached file.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    re: On off duty cycle chart not working for 2022

    The horizontal axis has fixed min/max values, which are currently 1/1/2021 - 1/1/2022
    You need to update those to 1/1/2022 - 1/1/2023
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-15-2021
    Location
    Abu Dhabi
    MS-Off Ver
    Office 2013
    Posts
    2
    Quote Originally Posted by Andy Pope View Post
    The horizontal axis has fixed min/max values, which are currently 1/1/2021 - 1/1/2022
    You need to update those to 1/1/2022 - 1/1/2023
    However, axis option is not showing in my system. the min maximum value should have to be from Cell T98 and U98- it is not working.
    Last edited by sham_33rtks; 12-15-2021 at 05:55 AM.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: On off duty cycle chart not working for 2022

    You will need to enable to horizontal axis first, then update the min/max.

    Your chart has it deleted. Better to format it so the line/labels/tickmarks are not displayed.

+ 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. [SOLVED] =TEXT Formula for 2022
    By Stenner in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-26-2021, 04:49 AM
  2. [SOLVED] Battery Duty Cycle Graph
    By dgdunn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-11-2021, 01:28 PM
  3. [SOLVED] Creating battery duty cycle diagram in Excel
    By Lekan17 in forum Excel General
    Replies: 6
    Last Post: 11-03-2020, 09:32 AM
  4. Replies: 2
    Last Post: 08-25-2017, 03:46 AM
  5. Cycle through sheets and drag down formula - Not working
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2013, 06:29 AM
  6. Trying to create a Duty Cycle graph.
    By Radar73 in forum Excel General
    Replies: 2
    Last Post: 11-07-2011, 03:59 PM
  7. [SOLVED] =?iso-2022-jp?B?V2hlcmUgZG9lcyAiYSwbJEIhSRsoQiBjb21lIGZyb20/?=
    By Mike in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-29-2006, 08:30 AM

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