Change starting date from January 1, 1900 to real date in chart

[esong_98]

My chart starts at January 1, 1900, but I want it to start on January 7, 2017. How do I do that?

[#2 · Accepted solution]

@esong_98 

Most probably you have zero values within Date column. It's better to remove zeroes. But in any case you may right click on axis->Format Axis and set range here

keeping Maximum on Auto.

[#3]

I solved my problem by copying the data from the Census Bureau Excel spreadsheet to my own Excel spreadsheet. My Excel spreadsheet automatically converts the data to the correct format. It looks like the US Census Bureau uses an old version of Excel.

[#4]

For some reason, the Census Bureau Excel spreadsheet didn't give me that option. However, my own spreadsheet does give me that option. Thanks for the response.

[#5]

@esong_98 , glad to know you sorted this out, thank you for the feedback.