How to create a drop line chart in Xcelsius

This post demonstrates a simple way to create a drop line chart using Xcelius’s out of the box combination chart. This is a fun chart great for mixing up your routine presentation layer.

What are drop lines?

Simply put, drop lines are lines that extend from a data point down (or up) to the horizontal axis. Drop lines help the viewer visualize the exact value of each point along the horizontal axis.

How to create:

1.  Add a combination chart to your canvas
2.  Add two series
3.  Select the same range of data for both series (one line series and one bar series)
4. Remove the legend by going to the “Text” tab under the “Appearance” properties
5. Remove the major and minor horizontal grid lines (leave major grid lines if expected to have negative numbers) found on the “Axes” tab under the “Appearance” properties.

6.  On the “Series” tab under the “Appearance” properties change the line shape to a circle, change the line color to match the chart background, and change the marker size to 1 under the column settings.

There you have it.

Let me know if you have any questions.

Configuring Sparkline Charts in Xcelsius

Are you using the latest Xcelsius service pack? If not, you may be missing out on a couple very useful charting components. By installing SP3 for Xcelsius, you’ll have the opportunity to use the following new chart components – Horizontal Bullet Chart, Vertical Bullet Chart, and Sparkline Chart. This blog post will focus on the Sparkline chart.

xcelsius-sparkline-chart

Continue reading →

How to implement an expiration date in an Xcelisus dashboard?

Here is an Xcelsius/Excel trick that allows you, the developer, to set a validity period on a dashboard. This is great for sharing demos or giving a potential client an evaluation period.

1. Setup your Excel file as follows

Continue reading →

Video: SAP Augmented Reality Explorer Prototype

Here is a short demo on SAP Augmented Reality Explorer Prototype by Timo Elliot. Timo explains how the Augmented Reality Explorer allows people to easily access information simply by pointing with the cell phone using the GPS location and the compass. I’m embedding the video here, but you can find all the details about the project on Timo’s blog.

Update Static Dashboards by Creating a Template with Formulas in Xcelsius

Have you ever developed a “one-off” dashboard in Xcelsius only to have it upgraded (by the boss or client) a couple months later to “we need that dashboard updated every quarter”? Many of you have probably been faced with this situation and needed to find a way to maintain and support an Xcelsius dashboard containing static (but evolving) data.

Ideally, you would connect your dashboard to a Data Manager connection type that allows data to be dynamically inserted into the model. Commonly used connection types for loading data dynamically are: Query as a Web Service, SAP NetWeaver BW, Live Office, or a Web Service from Web Intelligence Rich Client in BOE XI 3.1 SP2. But unfortunately, these connection types are sometimes a luxury and not always available. Sometimes data in Excel is your only data source.

So what to do when you’ve developed a fairly extensive model containing a large number of formulas and need to update the data?

Continue reading →