Getting Started

This page will help you get started building a dashboard with 2 widgets.

Start With Your Excel Data

Chartnado works with Excel data tables. Learn more about data tables here.

Open The Chartnado Dashboard Designer

From the Chartnado ribbon tab in Excel, click on Design.

Add A Widget

A new, empty dashboard will appear in the designer. Click Add Widget to choose from the list of availble widgets you can add to the dashboard.

Add A Chart

Select the Chart widget.

Select A Data Table

Chartnado works with all of the data tables in your Excel workbook. All data tables will be listed in the drop down.

Drag Columns Into The Widget

Each widget has multiple field lists that you can use to configure the widget. You can drag and drop fields between lists to change the display of the widget.

Review

A Chart widget normally has a field on the the axis/legend and one or more fields in the chart panes list.

(click on the image to see a larger version)

Change The Layout

By default, each new dashboard comes with a Stretch layout defined. Modify the properties of the Stretch layout.

(click on the image to see a larger version)

Choose The Layout

A Stretch layout allows for up to 4 rows and 4 columns.

Add Another Widget

Add another widget to your dashboard by clicking on Add Widget

(click on the image to see a larger version)

Add A Tree Map Widget

Add a new Tree Map widget to the dashboard.

Configure the Tree Map

Add fields to the Tree Map by choosing a table and dragging fields onto the widget.

Review The Tree Map

Continue to edit the properties of the Tree Map until you're satisfied.

(click on the image to see a larger version)

Preview The Dashboard

You can preview your dashboard in a web browser to see how it will look when it's published. You can choose from normal web browser, tablet and mobile phone layouts for the preview.

Web Browser Preview

This is how your dashboard will look when you publish it to the cloud.

(click on the image to see a larger version)

Where To Go From Here

You might also be interested in: