Line Chart Toolbar
Last updated
Last updated
The toolbar is located at the bottom of the chart. If it is not displayed, click the diagonal arrow in the lower-left corner of the chart. The toolbar contains the following functions:
Toolbar Button
Description
Data Configuration. Displays the Data Configuration window.
1. If more than one table was loaded using the ADVIZOR Data Wizard, use the pulldown list to select the applicable table. If a single table was loaded, it is the default.
2. Select a field from the Field pulldown list. This field will serve as the X axis in the displayed chart.
3. Optionally, you can select measures for Sum (you can select one or more fields), Average (select one field to be averaged) and/or Ratio (select a Numerator and Denominator field). If you select multiple measures, you can select Color Clusters By Measure. This allows you to distinguish between the measures.
4. Optionally, to display the line chart horizontally, place a checkmark in the Display Horizontally check box.
5. Click OK. The line chart displays.
Advanced Chart Properties The Property Explorer can be used to edit less frequently-used and/or advanced properties specific to an individual chart.
Exclude Unselected Items in this table first. Change Unselected rows in the table this chart is displaying to Excluded state, so they won't be visible in any chart. This change is then propagated to any other tables connected by selection links.
Exclude Selected Items in this table first. Change Selected rows in the table this chart is displaying to Excluded state, so they won't be visible in any chart. Any Unselected rows then become Selected. This change is then propagated to any other tables connected by selection links.
Rotate Chart. The Rotate Chart function switches the data displayed along the X axis and Y axis so that data currently displayed on the X axis will appear on the Y axis and data currently displayed on the Y axis will display on the X axis.
This function is available for Bar Charts, Histograms, and Line Charts.
Set Display Order. Click this button to choose a criterion for ordering the data points along the line:
Original order - The order the categories appear in the input table.
Sort By Label - Categories are displayed in alphabetical order of their labels.
Sort By Size - Categories are displayed in decreasing order of net size.
Sort By Selected - Categories are displayed in decreasing order of selected amount.
Sort By Percent Selected - Categories are displayed in decreasing order of selected percentage.
Reverse Sort By Label - Categories are displayed in reverse alphabetical order of their labels.
Reverse Sort By Size - Categories are displayed in increasing order of net size.
Reverse Sort By Percent Selected - Categories are displayed in increasing order of selected percentage.
Display Unselected Values. You can choose whether or not to display unselected data during analysis. By default, unselected data is displayed. By selecting this button, unselected data is excluded automatically for each selection.
Edit Chart Titles.... Use this function to change the content and font style of labels displayed in an active view.
In this dialog box, you can:
- Choose to display the Chart title text by placing a checkmark in the Display Title box.
- Add/edit the content of the Title, as well as change the font type, font style, font color, and point size of the Title text.
- Add/edit the content of Axis text, as well as change the font type, font style, font color, and point size of the Axis text.
- Change the font type, font style, font color, and point size of the Label text.
- Click OK to save your changes and close the dialog box.
Add Goal Line Goal lines can be placed at a fixed height for all categories. You can set the name, value, and color of the goal line. Additionally, the goal line can be used to select all categories with values above or below the goal line's value.
Label With Weights. Categories can be labeled with one of four weights. Selected Weight which shows the selected amount. Total Weight which shows the total weight of the category regardless of selections. Percent of Total which shows the percentage of the weight of the category compared with the total weight of all the categories. Percent of Category which shows the percentage of the weight selected within each category.
Chart Help. Opens this page in your browser.
Drill Down. Moving from summarized to a more-detailed level of data is known as drilling down. This button is only available when the Line Chart has been .
Drill Up. Moving from detailed-level to summary-level data is referred to as drilling up. It is useful when you want a simplified, "big picture" understanding of the information. This button is only available when the Line Chart has been .
