Now I always hate it when someone comes with an Excel chart that I have to duplicate. Excel is THE manupulation tool a user can have, thus ofcourse the chart capabilities are endless. And as Xcelsius is based on Excel, it is easy right?
But hey, I love challenges. So I got to work. Basically the chart had to display actual and ytd figures for 12 months for 5 different units. The chart was used as both a trend and a benchmark chart combined in one. Meaning first display 12 months for unit A (actual and ytd), then 12 months for unit B (actual and ytd) and so on.
After some tweaking I created more or less the same with the added benefit of zooming in on units and months. Note that data is not the same and colors, but that is easily solved later..
Just overlay 5 combination charts and create a range slider seperatly, instead of using the default one in the chart itself. That’s it.