Creating chart and setting parameters Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using PHPRunner
Working with projects
Templates
What are templates
Cars
Classified ads
Events
Jobs
Knowledge base
News
Paypal
Real estate
Sporting
Vacation houses
Connecting to the database
Datasource tables
SQL query page
About SQL query designer
Query Designer
SQL
Results
Charts
Creating chart and setting parameters
Chart appearance
Using SQL to shape chart data
Reports
Creating report and setting parameters
Report totals and layout
Choose pages
Login page
User login settings
Advanced security settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
"View as" settings
"Edit as" settings
Validation types
Lookup wizard
Events
Output directory settings
After you are done
FTP upload
FrontPage Publishing
Advanced topics
Events
More info about events
Global events
Table events
Page life cycle overview
Predefined actions
Send a simple email
Send an email with new data
Save new data in another table
Insert a record into another table
Check to see if a specific record exists
Display a message on the Web page
Redirect to another page
Custom code
Sample events
Show list of customer orders
Check if start date is ealier than end date
Before deleting a record check for related records
Speed up data entry using events
Publishing PHP application to the remote Web server
Using FTP client to publish PHP pages to the remote Web server
Using FrontPage to publish PHP pages to the remote Web server
Demo Account
What is the Demo Account?
Terms and Conditions
Connect using PHP
Master-details relationships
Using JOIN SQL queries
AJAX-based Functionality
PHPRunner session variables
Debugging tips
Template files processing rules (Files.txt)
Multilanguage support
Useful functions and links
Smarty templates
Stylesheets
Template language
How to control Inline Add/Edit functionality from script
Rich Text Editor plugins
Upgrade Guide from PHPRunner 3.0 and older
PDF view settings
Order PHPRunner online

 
  PHPRunner manual


Creating chart and setting parameters

 

To create a chart, proceed to Datasource tables and click Add Chart button.

On Chart Type tab select the type of chart to build.

Chart parameters tab

Choose Data Series fields. Some charts, such as Pie and Doughnut allow you to choose only a single Data Series. 2D Column Line chart requires two Data Series fields (one for column and another one for line). All other charts can have from one to four Data Series fields.

Data Series is a field with data. Only numeric fields can be chosen as a Data Series (numeric fields only are available for selection in Data Series dropdown box). Label field is basically a record identifier.

Here is a sample data table:

Make

Price

Mersedes-Benz

80,160

BMW

112,690

Acura

78,183

Jaguar

45,014

Porsche

44,465

Volvo

44,097

In this example we choose Price as Data Series, Make as Label which gives the following chart:

Sometimes the data in your database need to be processed before using in the chart. Check Using SQL to shape chart data topic for more info.

The CHM file was converted to HTML by chm2web software.