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.
A Chart widget normally has a field on the the axis/legend and one or more fields in the chart panes list.
Change The Layout
By default, each new dashboard comes with a Stretch layout defined. Modify the properties of the Stretch layout.
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
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.
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.
Where To Go From Here
You might also be interested in: