Creating a dashboard

You can follow these steps to create a dashboard using Xcelsius. For these steps, you must have data in an existing Excel spreadsheet.

To import the Excel spreadsheet

1.Open Crystal Xcelsius.
2.Close any windows within Xcelsius to create a blank work area.
3.To import an Excel file, select Data > Import Model.
4.In the Import Model dialog box, click the ellipsis to display the Open dialog box.
5.Navigate to the Excel spreadsheet. Click Open.
6.In the Import Model dialog box, click OK.

To build the visual model

After you import the spreadsheet, you must add components.

A component can be from the following categories:

Charts
Single Value
Selectors
Maps Library
Art & Background
Other
Text
Web Connectivity


If it is chart please follow the steps….

1.Select View > Components > Charts

2.Select the component and click on the work area to add the component.

3.Right click the component and select Properties from the menu.

4.The Properties window may have different tabs based on the components selected. The General tab controls the minimum required properties for the component to function. The tab contains the Data Source link properties that link the component to the Excel model.

5.Provide a description in the Chart subtitle, or make it blank.

6.In the Data Range box, click the Cell Reference icon.

7.A representation of the Excel model is activated with a dialog box that you use to select the desired range. Select a data range.

8.Click OK.