To chart the data, execute the query that produces data that you want to chart and choose Chart This Data from the popup menu in the result set. You can also press Chart This Data button in the result set toolbar located above the result set grid.
Select the chart type that you want from a dropdown list.
The following chart types are available:
XY Chart
Pie Chart
Bar Chart
Bat Chart (Categories)
For XY chart, choose parameters from the query result set that will be used for X and Y axis.
For Pie and Bar charts, choose parameters from the query result set that will be used for Category and Value. Optionally, change the maximum number of categories to display in a pie or bar chart. Default setting is to display 10 categories that have largest values. All other categories will be accumulated into a single category named “Other”.
Press OK button to open a chart document. The chart document has two tabs: Chart and Data. Chart tab displays the chart and data displays the grid of data that were used to build the chart.
Press Edit Chart definition button on Chart tab to edit chart parameters.
Righ-click on chart to open chart menu that allows to edit chart properties, such as a color, as well as zoom in/zoom out and save and print the chart.