Can Crystal Xcelsius replace Excel as a charting tool? As the regular readers know, I am creating an Xcelsius version of my Excel Demographic Dashboard to answer this simple question.

I am afraid the results until now are less than stellar. Although I could easily add four gauges with the four main demographic KPI, I am not really happy with the population pyramid and the barely passable scatter plot shows how limited Xcelsius’ data model is.

But today I am creating a simple line chart. Three variables and a dummy series. How difficult can it be?

xcelsius_line_chart

This is the result. As usual, the one on the left is the original chart and the one on the right is the Crystal Xcelsius version.

The Xcelsius version is much better rendered, that’s no surprise. But let’s put that aside for a moment and focus on the legend in the Xcelsius version. Notice anything bizarre? Bizarre like in the-legend-has-nothing-to-do-with-the-chart? The legend is using markers to identify the series but wait… I turned off the “Show Markers” option… Of course you can turn on the markers, set them to size 1 and use the same color as in lines. But still…

As far as I can see, you can’t directly label the series, so you can’t remove the legend. Removing the legend should always be a priority, according to the principle of simplicity in chart design.

I used a dummy series in the Excel version to place a marker along the X axis to mark the active year. This can’t be done in Xcelsius, since you can’t turn on the “Show Markers” option for a specific series.

Finally, the X axis is not labeled because it would become unreadable with labels for 60 years. Again, there is no obvious way to remove a defined set of labels. I suppose it could be done by removing the labels in the Excel file, but I didn’t test it.

Once again, Xcelsius failed to deliver a correct copy of a simple chart. There are some open-minded Xcelsius aficionados among the readers that will kindly prove me wrong and will share with us how to solve this issues…

We are almost done with this series of posts. Next time I’ll compare table layouts, before the last post, where I’ll discuss the overall conclusions.