Please enable JavaScript to view this site.

Navigation: Using PHPRunner > Charts

Chart parameters

Scroll Prev Next More

 

The Chart parameters screen allows you to choose the Data series fields (fields with data) and the Label field (field with data labels).

 

You can add any number of Data series fields. Additional data series dropdown boxes appear automatically once you've used the available ones.

 

For more information about choosing the Data series fields for certain chart types, see Chart types.

chart_parameters

 

Total options are: AVG, MIN, MAX, COUNT and SUM. If you select the total data will be grouped by this field automatically. You also get an option to select grouping interval. For date fields it will have options like month, year and day. Numeric fields will have options like 10s, 100s and 1000s. Text fields will have interval options like first letter, first two letters etc.

 

 

Here is the chart that will be built based on the settings above.

 

 

scr_date_groupping_in_charts

 

 

Here is an excellent video that covers grouping in charts.

 

To further customize the chart appearance like colors, fonts, or the chart title, use the ChartModify event.

See also:

Creating charts

A list of chart types

Chart appearance

Using SQL to shape chart data

ChartModify event

Datasource tables

Master-details relationship

 

Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software