|
Xcelsius Components - Multi Color Column Chart |
PDF |
| Print | |
E-mail |
| Multi Colour Column Chart | | Overview | | Overview | | Demos | |
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
|
| | Multi Colour Column Chart component lets you configure the colour of each bar/column based on color values stored in the database/excel sheet. This allows the colour of a specific data item to remain constant when the results change in the query result. In an Xcelsius standard PIE chart, the colour configuration is based on specific rows in the excel sheet. The user can only configure the colour for a specific row (red for 1st row, green for 2nd row). This limits the user to associate a particular colour to a particular data value in the data store.
For e.g. The data values in the excel sheet for a specific period are ‘Apple’, ‘Orange’, ’Lemon’ and the respective colour codes assigned are ‘red’, ’orange’, ’yellow’ (based on the respective excel rows) and over a period new values like ‘papaya’, ’grapes’, ’guava’ get filled in the same rows(based on data set from the data store), the same colour code ‘red’, ’orange’, ’yellow’ will be displayed instead of the desired values ‘papaya green’, ’purple’, ’green’. With this component, user will be able to map the colour with a specific data value. For eg:, the user can add an additional column in the dimensional table to represent the colour code and hence the colour can be based on the actual values itself rather than on specific excel rows. Hence in the above example, ‘red’ will be consistently displayed for ‘Apple’, ‘Orange’ for ‘Orange’, … | Other Xcelsius Components | | The Standard Xcelsius components do not allow step by step multilevel drill down feature like the web intelligence document. This is because the standard Xcelsius graph does a drill down on a data change event. For e.g if the requirement is to display country wise revenue while loading and then by clicking on a specific country column ‘India’, s/he would like to display the state level revenue in the same graph, it is quite very difficult to achieve this with the standard Xcelsius chart component through various workarounds. Multi Colour Column Chart allows drill down only when the user actually clicks on a column and not on a data change event. This enables the developer to build a dashboard with a step by step multi level drill down capability.
The current version supports only 1 type of insertion while drill down; the label type. The future releases will support rest of the
insertion types.
Another cool feature in this component is the ‘Staggered Axis Label’. In the standard Xcelsius chart components, the axis labels get transposed to a vertical alignment in case of a long text, thus making it unreadable and reducing the graph area. In our component, the axis labels will be staggered in cases of long text and if it still needs more space a partial text will be displayed with dots. Moreover provisions are provided to make the margins configurable through spin buttons, thus allowing more readability of the axis labels.
|
|