How to Use Both Axes for Effective Dashboard Charts

An effective dashboard allows you group new and existing information quickly and seamlessly. To plot multiple datasets on the same chart, simply drag multiple measures into the ‘Y’ field of the ‘Data’ panel. To break out a dataset into a subseries, drag the desired subseries dimension into one of the fields in the ‘Visual’ panel (‘Color’, ‘Shape’, ‘Size’, ‘Text’).

The following sections explain various aspects of working with multiple datasets and subseries. To set the chart style for an individual dataset on a multi-dataset chart, follow the steps below:

1. Click ‘Switch to Single Graph’ in the title bar of the ‘Data’ panel. This changes the view to present all of the datasets on the same axes.
2. Click the ‘Select Chart Type’ button next to dataset you wish to change. This opens the Chart selection menu.
3. Choose the desired chart type, and click ‘Apply’.

By default, when you specify two datasets on the Y-axis, the two datasets are plotted on two adjacent sets of axes. If you want the two datasets to appear on the same set of axes, click the ‘Switch to Single Graph’ button.

This example illustrates how to switch from a multiple axis view to a singleaxis view. Follow the steps below:

1. Create a new Viewsheet based on the sample ‘Analysis’ Worksheet.
2. Add a chart component, and click the ‘Edit’ button. This opens the Chart Editor.
3. In the ‘Data Source’ pane, expand the ‘OrdersAndReturns’ data block.
4. From the ‘Dimensions’ node, drag the ‘State’ field to the ‘X’ field of the ‘Data’ panel.
5. In the ‘Measures’ node, Ctrl-click to select both the ‘TotalPurchased' field and the ‘TotalReturnedNeg’.
6. Drag both fields together to the ‘Y’ field of the ‘Data’ panel.
7. Click the ‘Switch to Single Graph’ button in the ‘Data’ panel. This fits both datasets on the same set of axes, and removes the scrollbars.
8. If desired, edit the Y-axis label to fit on the chart.