Build 4.5.0.31 of xlsgen adds support for rendering date-based category axis in charts.

Before this build, dates in categories (the X axis of the chart) would be taken as strings. In fact, dates are more interesting than strings because between 2 or more dates, the distance along the X axis shows how far they differ, so there is an opportunity to treat dates as a XY chart, i.e. the X axis has scale options exactly like the Y axis.

Here is an example of showing date-based category axis before build 4.5.0.31 :

You may notice the distance between categories is the same regardless the difference between dates


showing date-based category axis before build 4.5.0.31

And now, without changing a line of code, an actual date-based rendering :

showing date-based category axis now in xlsgen