Home

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
seidkat
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

@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

 

@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

 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies