Forum Discussion
esong_98
Jul 27, 2023Copper Contributor
Change starting date from January 1, 1900 to real date in chart
My chart starts at January 1, 1900, but I want it to start on January 7, 2017. How do I do that?
- Jul 27, 2023
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.
SergeiBaklan
Jul 27, 2023MVP
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.
esong_98
Jul 27, 2023Copper Contributor
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.
- SergeiBaklanJul 27, 2023MVP
esong_98 , glad to know you sorted this out, thank you for the feedback.