Help! not all the dates are appearing on my excel graph

[jasperc]

Screen Shot 2015-07-31 at 6.10.55 PM.png

my dates are on the x-axis. Can anyone help explain why i am not able to see all the dates on the graph? I have data for everyday from 2012.

Edit: uploaded xls workbook and csv file.

[Pete_UK]

If you must submit a picture, do it as a PDF file, as many browsers are unable to view PNG files on this Forum.

Better still, attach an Excel Workbook - the FAQ describes how to.

Pete

[niks28]

Hi,
The Database that you have selected is beyond 2000, wherein the data required for chart is till 934 . Kindly edit the chart and keep range what is required and exclude the empty cells to get a better chart view.
Also note that as data is huge so you have to resize the chart to get all Dates visible or else all would be crumbled in alternatively you can select Interval unit to get better chart view or add another column with month and year TAG and use that as database to your chart.
Hope this would resolve your issue.
Cheers!

[jasperc]

Hey dude! Thank you so much! I fixed the view by selecting the data from 934 onwards and that worked great. However i realised that i have to resize to see all the dates. I need to see the data for every day, so i cant group it in year and months. Also where do i go to select Interval unit?

[niks28]

Just Double click on the chart data itself and it will pop up for arrangement.