date formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2273198%22%20slang%3D%22en-US%22%3Edate%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2273198%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20the%20long%20list%20of%20dates%20on%20the%20right%20over%20the%20chart%20to%20begin%20in%202021%2C%20not%202017.%26nbsp%3B%20How%20can%20I%20change%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2273198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I need the long list of dates on the right over the chart to begin in 2021, not 2017.  How can I change this please?

5 Replies

@bethany1124 

Double-click any of the dates in the x-axis at the top.

Under Axis Options, tick the check box 'Values in reverse order'.

 

S0297.png

Thank you for your response. Is there a way to delete the prior dates? I don't want any dates prior to 2021 in there.
I need the date to start from01/01/2021 from the beginning of the chart and go to 12/31/2021

@bethany1124 

Enter 01/01/2021 in a cell (for example in another workbook).

Change the number format of that cell to General.

You'll see the number 44197. This is how Excel stores 01/01/2021 internally.

Do the same for 12/31/2021. The corresponding number is 44561

Now double-click an x-axis label again.

Under Axis Options, set Minimum to 44197 and press Enter.

Then set Maximum to 44561 and press Enter.

@Hans Vogelaar You are a genius! This worked, thank you so much!