The dates change from the last in the month (in table) to the first in next month (in diagram)

%3CLINGO-SUB%20id%3D%22lingo-sub-1150127%22%20slang%3D%22en-US%22%3EThe%20dates%20change%20from%20the%20last%20in%20the%20month%20(in%20table)%20to%20the%20first%20in%20next%20month%20(in%20diagram)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1150127%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EIm%20trying%20to%20make%20a%20diagram%20based%20on%20some%20values%20and%20dates.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20dates%20in%20the%20table%20is%20the%20last%20of%20each%20mounts.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFor%20example%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E30.06.2012%20-%20Value%20100%3C%2FP%3E%3CP%3E31.07.2012%20-%20Value%20103%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EWhen%20Im%20transfering%20this%20information%20in%20to%20a%20diagram%2C%20the%20horizontational%20axis%20in%20the%20diagram%20shows%20the%20first%20date%20in%20the%20next%20month.%20This%20is%20not%20favorable%20when%20I%20am%20going%20to%20present%20my%20information%20to%20others.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFor%20example%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E01.07.2012%20-%20Value%20100%3C%2FP%3E%3CP%3E01.08.2012%20-%20Value%20103%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1150127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1150161%22%20slang%3D%22en-US%22%3ERe%3A%20The%20dates%20change%20from%20the%20last%20in%20the%20month%20(in%20table)%20to%20the%20first%20in%20next%20month%20(in%20diagram)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1150161%22%20slang%3D%22en-US%22%3EBy%20default%2C%20if%20you%20have%20dates%20as%20one%20thing%20in%20an%20Excel%20chart%2C%20it%20will%20fill%20in%20the%20whole%20timeline%20as%20the%20axis%20(and%20will%20label%20the%20month%20start%20dates%20by%20default).%20You%20could%20change%20the%20format%20of%20the%20axis%20labels%20to%20only%20show%20the%20month%20name%20and%20not%20the%20rest%2C%20for%20example%2C%20or%20you%20could%20format%20the%20original%20data%20as%20text%20and%20Excel%20would%20replicate%20the%20labels%20exactly.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1150274%22%20slang%3D%22en-US%22%3ERe%3A%20The%20dates%20change%20from%20the%20last%20in%20the%20month%20(in%20table)%20to%20the%20first%20in%20next%20month%20(in%20diagram)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1150274%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1151163%22%20slang%3D%22en-US%22%3ERe%3A%20The%20dates%20change%20from%20the%20last%20in%20the%20month%20(in%20table)%20to%20the%20first%20in%20next%20month%20(in%20diagram)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1151163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F544521%22%20target%3D%22_blank%22%3E%40Inga1992%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDepends%20on%20which%20type%20of%20chart%20you'd%20like%20to%20have%2C%20as%20variant%20you%20may%20use%20scatter%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20550px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169020iFF5884E109A7221C%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%3C%2FLINGO-BODY%3E
New Contributor

Hi,

Im trying to make a diagram based on some values and dates. 

The dates in the table is the last of each mounts. 

For example:

30.06.2012 - Value 100

31.07.2012 - Value 103


When Im transfering this information in to a diagram, the horizontational axis in the diagram shows the first date in the next month. This is not favorable when I am going to present my information to others. 

For example:

01.07.2012 - Value 100

01.08.2012 - Value 103

3 Replies
By default, if you have dates as one thing in an Excel chart, it will fill in the whole timeline as the axis (and will label the month start dates by default). You could change the format of the axis labels to only show the month name and not the rest, for example, or you could format the original data as text and Excel would replicate the labels exactly.

@Inga1992 

Depends on which type of chart you'd like to have, as variant you may use scatter

image.png