Chart Date Range on Axis

%3CLINGO-SUB%20id%3D%22lingo-sub-500614%22%20slang%3D%22en-US%22%3EChart%20Date%20Range%20on%20Axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500614%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20given%20this%20document%20(attached%20to%20this%20post)%20-%20I%20didn't%20create%20it%20but%20have%20been%20asked%20to%20work%20with%20it.%20In%20the%20chart%20from%20Row%202%20to%20Row%2026%2C%20shows%20projects%20as%20bars%20to%20indicate%20their%20duration.%20They%20have%20a%20start%20date%2C%20populated%20from%20the%20Begin%20column%20on%20Worksheet%202.%20The%20project%20duration%20comes%20from%20the%20Duration%20column%20on%20Worksheet%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20can't%20work%20out%20how%20to%20get%20the%20dates%20on%20the%20Axis%20of%20the%20chart%20to%20change.%20Currently%2C%20the%20dates%20on%20the%20chart%20are%20dates%20in%202016.%20My%20projects%20started%20in%202018%20at%20the%20earliest%2C%20so%20they%20don't%20even%20appear%20on%20the%20chart.%20When%20I%20put%202016%20dates%20in%20the%20Begin%20column%2C%20those%20projects%20appear%20on%20the%20chart.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20date%20range%20shown%20on%20the%20chart%20to%20reflect%20the%20dates%20in%20the%20Calendar%20column%20on%20Worksheet%202.%20How%20can%20I%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-500614%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-500998%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20Date%20Range%20on%20Axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329938%22%20target%3D%22_blank%22%3E%40seidkat%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20try%20to%20format%20X%20axis%20you'll%20see%20what%20min%20and%20max%20ranges%20are%20defined%20for%20it.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20289px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111001iD243E549645F78FF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20may%20reset%20them%20or%20define%20another%20bounds%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20926px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111003i4E04D80174396A5B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-502609%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20Date%20Range%20on%20Axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-502609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20your%20reply.%20I%20wasn't%20sure%20what%20to%20change%20the%20numbers%20to%20as%20they%20are%20numbers%20and%20not%20dates%2C%20but%20I%20just%20tried%20random%20numbers%20until%20the%20date%20range%20looked%20right.%20Thank%20you!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-505992%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20Date%20Range%20on%20Axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-505992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329938%22%20target%3D%22_blank%22%3E%40seidkat%3C%2FA%3E%26nbsp%3B%2C%20in%20Excel%20dates%20are%20integer%20numbers%20starting%20from%201%20which%20is%2001%20Jan%2C%201900.%20Another%20story%20you%20have%20the%20possibility%20to%20format%20such%20numbers%20as%20dates%20and%20work%20with%20them%20as%20with%20dates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20type%20any%20date%20inti%20the%20cell%20and%20after%20that%20apply%20General%20format%20to%20that%20cell%20you'll%20see%20the%20equivalent%20nubmer.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20249px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111214i635E347E73E9CB85%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I have been given this document (attached to this post) - I didn't create it but have been asked to work with it. In the chart from Row 2 to Row 26, shows projects as bars to indicate their duration. They have a start date, populated from the Begin column on Worksheet 2. The project duration comes from the Duration column on Worksheet 2.

 

However, I can't work out how to get the dates on the Axis of the chart to change. Currently, the dates on the chart are dates in 2016. My projects started in 2018 at the earliest, so they don't even appear on the chart. When I put 2016 dates in the Begin column, those projects appear on the chart. 

 

I want the date range shown on the chart to reflect the dates in the Calendar column on Worksheet 2. How can I do this? 

3 Replies
Highlighted

@seidkat ,

 

If you try to format X axis you'll see what min and max ranges are defined for it.

image.png

You may reset them or define another bounds

image.png

 

Highlighted

@Sergei Baklan thank you for your reply. I wasn't sure what to change the numbers to as they are numbers and not dates, but I just tried random numbers until the date range looked right. Thank you! 

@seidkat , in Excel dates are integer numbers starting from 1 which is 01 Jan, 1900. Another story you have the possibility to format such numbers as dates and work with them as with dates.

 

If you type any date inti the cell and after that apply General format to that cell you'll see the equivalent nubmer.

image.png