Chart Data Wizard Window

There are three main windows to the chart wizard. There is a window to define the chart type and the series, a window to define data points, and a window to set up basic style elements such as the title and axes labels.

Chart Data Wizard (Step 1 of 3) - Series

Chart Type - Determines the chart type. The following are chart types supported by Stratum.Viewer: Area, Bar, Bubble, Column, Combinational, Doughnut, Line, Pie, Point, Spline, Spline Area, Stacked Area, Stacked Area (100%), Stacked Bar, Stacked Bar (100%), Stacked Column, Stacked Column (100%), and Step Line.

Series From - Series are a group of related items (data points) that are included in a chart. Series can be created from either the rows or columns of the view grid.

3D - Select this checkbox if you want the chart to be three dimensional.

Series: Dynamic - All grid rows or columns will be charted when the series are dynamic.

Totals and All Others - Options are provided for showing Totals and All others data when series are dynamic. Dynamic series will graph all rows or columns displayed in the view grid.

Notes: Series and data points can be a mixture of dynamic or static in your chart. For example, series could be dynamic while data points are static.

Series: Static - If the series are static, only the selected rows or columns from the grid will be charted. If you select Static, options display to select the values for the series. Clicking Add opens an additional selection window. See Chart Data Wizard (Step 1b of 3) – Static Series.

Next, Finish, Cancel - Click Next to define the chart’s data points, Finish to complete the chart without further customization, or Cancel to close the Chart Data Wizard without creating a chart.

Chart Data Wizard (Step 1b of 3) – Static Series

Chart Type - The selected chart type is displayed here. When the chart type is set to “Combinational”, Chart Type must be defined for each series. Chart type is display only for all other chart types.

Values - Displays the static series for the chart. To add new series, click Select within the Chart Data Wizard window; the highlighted measure items or members from the grid are added as static series for the chart and display in this area.

Copy Data Point From - If you edit an existing chart and are adding a new series, you can use the “Copy Data Point From” property to create data points for the new series. This is useful when adding a new series and you want the data points for the new series to be the same as those for an existing series.

Select - Clicking Select will add the highlighted rows or columns from the Viewer grid as series for the chart. Tip: Use the selector cells when highlighting a row or column that you want to use as the series for a chart. For rows, the selector cell is the blank cell space along the left edge of it in the grid. For columns, the selector cell is the blank cell space above the column at the top of the grid. After making your selections in the grid, then click Select in the chart wizard and then click Done. Here’s an example of selector cells and a highlighted column:

Done - Click Done to complete the process of defining the static series and redisplay the Chart Data Wizard (Step of 1 of 3) – Series window with the static series identified. You can reorganize the positioning of the static series within the chart using the Up  or Down  arrow buttons within the newly displayed window.

Chart Data Wizard (Step 2 of 3) – Data Points

Data Points: Dynamic - Data points can be created from either the rows or columns of the grid. If series were defined from the rows, then data points will be the grid’s columns, and vice versa. All grid rows or columns will be charted for dynamic data points.

Totals and All Others - Options are provided for showing Totals and All others data when data points are dynamic. Dynamic data points will graph all rows or columns displayed in the view grid.

Data Points: Static - If the data points are static, only the selected rows or columns will be charted. If you select Static, options display to select the values for the data points. Clicking Add opens an additional selection window similar to the window for static series. See Chart Data Wizard (Step 1b of 3) – Static Data Points.

Chart Data Wizard (Step 2b of 3) – Static Data Points

Y-Values - Displays the static data points for the chart. To add new data points, click Select within the Chart Data Wizard window, and the selected members or measure items display in this area.

X-Values {Optional} - You can optionally add data points to the X axis. Highlight the static data points (rows or columns) in the grid. Once you click Select, the measure items display in this area.

Select - Clicking Select (in both the Y-Values and the X-Values area) will add the highlighted rows or columns from the Viewer grid as data points for the chart. Tip: Use the selector cells when highlighting a row or column that you want to use as the data points for a chart. For rows, the selector cell is the blank cell space along the left edge of it in the grid. For columns, the selector cell is the blank cell space above the column at the top of the grid. After making your selections in the grid, then click Select in the chart wizard and then click Done. Here’s an example of selector cells and a highlighted column:

Clear - Clears any values currently selected and displayed on the window.

Done - Click Done to complete the process of defining the static data points and redisplay the Chart Data Wizard (Step of 2 of 3) – Data Points window with the static data points identified.

Chart Data Wizard (Step 3 of 3) - Style

Titles - Customize the look of the chart titles. The Chart Title defaults to the view title. The X-Axis Title is the label for the horizontal axis. The Y-Axis Title is the label for the vertical axis.

Axes - Use this area of the window to hide the axis labels. They are displayed by default.

Legend - Use this area of the window to control the visibility and positioning of the chart legend.  The chart’s legend can display at the top, bottom, left, or right of the chart area.