Excel 2007: Using a time to set XY chart axis scaling like in 2003
- by CookieOfFortune
In Excel 2003, when you created a XY chart using time as an axis, you could set the scaling of these axes by typing in the date. In Excel 2007, you have to use the decimal version of the time (eg. How many days since some arbitrary earlier date). I was wondering if there was a way to avoid having to make such a calculation?
A developer posted on…