Xcelsius chart versus Excel chart

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?

…. 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.

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Excel, Other, Xcelsius and tagged , , , . Bookmark the permalink.

2 Comments to Xcelsius chart versus Excel chart

  1. Carol says:

    Again…thank you for sharing your creativity & ideas. This is so great and I will definitely attempt to try this one….

  2. Santosh says:

    hello Xcelsius Guru, i am one of your fan who frequently visit your site. Can you share in detail as to how did you do this. This is really cool idea. thanks for your effort and information.