chart does not pick up last values

[Anu Sharma]

1) I have dates on x axis and numbers on y axis.
2) When I create the chart, it does not pick up.

 

[Asheesh]

Anu, this looks like an issue with the data range. However, please share the workbook for exact solution..

 

[Luke M]

Hi Anu,

Would it be possible to upload the actual workbook w/ issue? Just looking at the picture, it's hard to know/guess what is wrong.

 

[Anu Sharma]

uploaded

 

[David Evans]

Change your formatting on the dates and the problem will become apparent - the Dec 21 and 28 were in 2016, nor 2015 ...

 

[John Jairo V]

¡Hi to all!

@Anu Sharma. Check the year into I2 and J2. Blessings!