Chart

The Adaptam Chart tab works very much like the Visualizer, but its data source is spreadsheet cell ranges instead of data fields. Once the data ranges are selected, the same chart settings and sidebar options are available.

Overview

The Chart tab lets you:

• Build charts from worksheet ranges
• Choose chart types and data orientation
• Define axis and legend inputs
• Edit titles directly on the chart
• Control labels, legend display, and gridlines from the settings sidebar

Data Setup

The chart data setup sidebar is where you choose the spreadsheet source tab, chart type and select the data input ranges.

1. Chart Type — Selects the chart type.
2. Data from — Chooses which worksheet provides the source data.
3. Data input — Opens the range selector for the chart data.
4. First row is legends — Uses the first row as legend labels.
5. First column is x axis labels — Uses the first column as X-axis labels.
6. Switch rows/columns — Swaps whether rows or columns act as legends and axis labels.
7. X axis values — Defines the X-axis input range.
8. Legend values — Defines the legend input range.

Selecting all the Data in a single Range

With First row is legends, First column is x axis labels, and Switch rows/columns set, the Data input selector accepts a single range that covers all the data.

Clicking the Data input selector automatically takes you to the sheet previously specified so you can select the range with all the data.

Organizing Rows and Columns

Click the Switch rows/columns check box to flip which side of the data is used for legends versus the X axis.

Any chart can be reduced to a one-dimensional setup by supplying the data input and axis input. For pie charts, the chart uses data input plus legend input instead of an axis input.

Specifying Data Inputs Separately

Instead of using a single range, you can supply the axis and legend inputs separately. This can be done for one or all of the data inputs.

Unclicking First row is legends opens the Legend values selector:

Unclicking First column is x axis labels opens the X axis input selector:

Unclicking both check boxes opens all three inputs so each range can be set explicitly. In this situation the Data input only populates the values for the body of the chart.

On-Chart Settings

Several chart labels can be edited directly on the chart.

9. Title — Double-click to edit the chart title.
10. Y axis title — Double-click to edit the Y-axis title.
11. X axis title — Double-click to edit the X-axis title.
12. Legend — Double-click to edit the legend heading.

Settings Sidebar

The settings sidebar lets you change chart settings and another way to input titles.

13. Settings — Opens the settings panel.
14. Title — Sets the chart title from the sidebar.
15. Y Scale title — Replaces the Y-axis title.
16. Increments — Overrides the automatic Y-axis increments.
17. Location — Moves the Y-axis from left to right.
18. Min — Sets the Y-axis minimum.
19. Max — Sets the Y-axis maximum.
20. Labels — Turns data labels on or off.
21. Missing data — Chooses how missing data is handled.
22. Legend title — Replaces the default legend heading.
23. Coloring — Controls whether legend colors appear as boxes, labels, or both.
24. X Scale title — Replaces the default X-axis title.
25. Gridlines — Controls which gridlines are shown.
26. Sidebar toggle — Hides the sidebar.

Hidden Sidebar

27. Sidebar toggle — Reopens the hidden sidebar.