Dynamic Web Charts: Data Tab

The Data tab allows you to set the properties for the data that the chart will display.

Choose either Static or Dynamic from the radio buttons, depending on the type of data you plan to display in your chart. The options available in this tab change based on your selection.



Static

By default the Static radio button is selected, allowing you to manually enter the data to display in your chart.
  • Get Data from CSV: Allows you to specify a comma-separated values file that contains your data, to be imported into your chart. This data can be modified by the fields below. A sample CSV file has been provided for reference in the Additional Resources section.
  • Clear sample data: Removes sample data from all fields allowing you to enter your own data.
  • Reset sample data: Replaces all content in fields with the original sample data.
  • Labels: Enter the values for the X-axis labels. Each value must be separated by the pipe character, |.
  • Values: Enter the values for the Y-axis labels. Each value must be separated by the pipe character, |.
  • Links: Allows you to specify URLs for each data point. This option is not available for the Area chart type. Each URL must be separated by the pipe character, |.
    These links are not active in the Preview window.
  • Dataset label: Enter a label for your dataset.
  • Dataset label style: Specify the type size and color for your dataset label.
  • Line/Fill color: Specify the line or fill color of each data segment. For Line and Area chart types, this would be a line color. For Pie and Bar charts, this would be the fill color for each data segment.
  • Outline color: Specifies the line color for the outline around any data segment. This line does not appear on all chart types or specific subtypes.
  • Edit Color(s): The Edit Colors window allows you to specify the colors to be used for each of your data segments. More information on the Edit Colors window can be found here.

Entering the pipe character:

On most keyboards, holding down the Shift key and pressing the backslash "\" key will enter the pipe character.



Dynamic

Select the Dynamic radio button if you wish to have your chart display dynamic data from a recordset.
  • Connection: Choose from any database connection currently created in your Dreamweaver site.
  • Data source: Choose the database table you intend to use for your chart.
  • X Label: Choose the column from your database you intend to use for your X Values.
  • Group by: Groups all same data in the X label column as one data point in your chart. If the database column selected in the X Label menu contains dates, the options will be, Value, Day, Week, Month or Year. For all other database columns, Value or None are the only options available.
  • Range from: Allows you to use the Date Picker to select the start date for any grouping by date.
  • Range to: Allows you to use the Date Picker to select the end date for any grouping by date.
  • Y Value: Choose the column from your database you intend to use for your Y Values.
  • Calculation: Allows you to specify how you would like the values for grouped data to be presented in your chart. Options available are, Average, Count, Max, Min, and Sum.
  • Dataset label: Allows you to specify a label for your dataset.


Filtering and sorting

This section allows you to apply any filtering or sorting to your recordset to customize the way the data is displayed in your chart.
  • Filter: Choose from the menu list, the database column to filter your results based on. Then choose from the other 3 menu lists that become active, the specific criteria to filter the selected column by.
  • Sort: Choose the database column you intend to have your data sorted by.
  • Show multiple datasets from column: Check this box and select a database column from the menu list, to have your chart data separated based on a value in this column. This would be useful if you wanted to show total sales over a given period on your chart, but have separate data columns for each of your products. Styles
  • Dataset label style: Specify the type size and color for your dataset label.
  • Line/Fill color: Specify the line or fill color of each data segment. For Line and Area chart types, this would be a line color. For Pie and Bar charts, this would be the fill color for each data segment.
  • Outline color: Specifies the line color for the outline around any data segment. This line does not appear on all chart types or specific subtypes.
  • Edit Color(s): The Edit Colors window allows you to specify the colors to be used for each of your data segments.


Preview

The Preview pane displays a representation of your chart based on the configuration options you have specified. You can test the interactivity of the chart by running your mouse over each data point or area. Unlike other WebAssist products, the preview is only displayed in the Dynamic Web Charts interface and does not display in your primary browser when clicked.

Note: The Preview area only displays static data whether dynamic data is selected or not.