SOLVED
Home

Strange Dates Showing Up in Graph

%3CLINGO-SUB%20id%3D%22lingo-sub-735005%22%20slang%3D%22en-US%22%3EStrange%20Dates%20Showing%20Up%20in%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735005%22%20slang%3D%22en-US%22%3E%3CP%3EHey%2C%3C%2FP%3E%3CP%3ESo%20recently%20I've%20been%20working%20on%20analytical%20data%2C%20but%20I've%20run%20into%20a%20strange%20problem%20during%20graphing.%20My%20data%20is%20organized%20by%20the%20date%2C%20so%20when%20I%20go%20to%20graph%20I%20try%20to%20graph%20with%20that.%20The%20problem%20is%20is%20that%20no%20matter%20what%20I%20do%20it%20puts%20the%20wrong%20dates%20into%20the%20axis.%20My%20data%20is%20from%201%2F16%2F1995-12%2F16%2F2014%20but%20it%20puts%20the%20axis%20at%201%2F0%2F1900-10%2F26%2F1900.%20I've%20tried%20converting%20the%20numbers%2C%20tried%20messing%20with%20the%20number%20bit%20on%20the%20axis%20options%2C%20but%20nothing%20works.%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-735005%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735012%22%20slang%3D%22en-US%22%3ERe%3A%20Strange%20Dates%20Showing%20Up%20in%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370106%22%20target%3D%22_blank%22%3E%40JessicaMeyer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20sample%20excel%20file%20to%20help%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735265%22%20slang%3D%22en-US%22%3ERe%3A%20Strange%20Dates%20Showing%20Up%20in%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735265%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370106%22%20target%3D%22_blank%22%3E%40JessicaMeyer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20dates%20are%20not%20added%20as%20X%20axis%2C%20thus%20you%20have%20sequential%20numbers%20instead.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20440px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121987iB11BB8EB9973B397%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%3EIf%20you%20apply%20Date%20format%20to%20axis%20it'll%20be%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20274px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121988i89D83E9765F77D53%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%3Esince%20dates%20are%20just%20numbers%20starting%20from%201%20which%20is%20equal%20to%20Jan%2001%2C%201900.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735322%22%20slang%3D%22en-US%22%3ERe%3A%20Strange%20Dates%20Showing%20Up%20in%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735322%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%3BI%20was%20hoping%20to%20not%20have%20to%20do%20that%20because%20other%20graphs%20I%20have%20have%20worked%20without%20doing%20the%20numbers%2C%20but%20I%20gave%20up%20and%20figured%20out%20the%20numbers%20for%20each%20date.%3C%2FP%3E%3C%2FLINGO-BODY%3E
JessicaMeyer
New Contributor

Hey,

So recently I've been working on analytical data, but I've run into a strange problem during graphing. My data is organized by the date, so when I go to graph I try to graph with that. The problem is is that no matter what I do it puts the wrong dates into the axis. My data is from 1/16/1995-12/16/2014 but it puts the axis at 1/0/1900-10/26/1900. I've tried converting the numbers, tried messing with the number bit on the axis options, but nothing works. Please help.

3 Replies

@JessicaMeyer 

I need a sample excel file to help you

Solution

@JessicaMeyer 

As variant dates are not added as X axis, thus you have sequential numbers instead.

image.png

If you apply Date format to axis it'll be like

image.png

since dates are just numbers starting from 1 which is equal to Jan 01, 1900.

@Sergei Baklan I was hoping to not have to do that because other graphs I have have worked without doing the numbers, but I gave up and figured out the numbers for each date.

Related Conversations