Forum Discussion
Chart Date Range on Axis
Hi, I have been given this document (attached to this post) - I didn't create it but have been asked to work with it. In the chart from Row 2 to Row 26, shows projects as bars to indicate their d...
seidkat ,
If you try to format X axis you'll see what min and max ranges are defined for it.
You may reset them or define another bounds
SergeiBaklan thank you for your reply. I wasn't sure what to change the numbers to as they are numbers and not dates, but I just tried random numbers until the date range looked right. Thank you!
seidkat , in Excel dates are integer numbers starting from 1 which is 01 Jan, 1900. Another story you have the possibility to format such numbers as dates and work with them as with dates.
If you type any date inti the cell and after that apply General format to that cell you'll see the equivalent nubmer.