Q.5. Build a chart

To build a chart, you must first select the data source that you would like to use. Select either the query that you created or the StartGuide text file and click the Next button. A new window will open showing the first twenty records of data.

Click to view larger image

From this dialog click Next again. A dialog will appear asking you to process data or to get another data source. Select Process Data and click Next.

The next screen in the chart wizard allows you to select the chart type that you would like to use. You can toggle between two-dimensional and three-dimensional chart types using the radio buttons. Select a two-dimensional column chart as the type that you would like to use and click Next.

Click to view larger image

The next screen allows you to set data mapping for the chart. Data mapping is the process by which the columns of data from your data source are mapped to the elements of the chart. By default the first column from left to right (CategoryName) will be mapped as the data series, the second (Region) column as the categories, and the third (Quantity) column as Value. To modify the mapping, select Region as the data series and CategoryName as the categories. Leave the Value option the same.

Click to view larger image

Once you have made the required changes, click on Apply and the chart will be re-drawn in the mapping window to reflect the changes. Once you have finished setting the mapping options, click Done and you will go to the Chart Designer window where you can customize the chart.