Criteria displayed in the Design worksheet can be designed, charted and embedded in the worksheet. Charts can then be analysed directly on the Chart View dialog box using drill options that appear when you select a chart point.
Charts can be defined and embedded in a worksheet that is linked to the worksheet criteria. They can then be analysed using Drill options that appear when a chart series is selected.
The charting facility is immensely flexible and powerful. Various chart types are available and all elements can be customized as required, for example, colours, shading and the axis.
Data to be charted must be continuous in a single selection range, i.e., there must be no spaces between the data. Column and row labels must also be included. Use defined names to reference any cells within the worksheet to a chart and ensure that sufficient rows are available to display worksheet charts.
To begin creating a chart:
- Select the area containing the data you want to chart. You can select titles and labels now or enter them later using the Wizard or Chart Designer.
- Either click Insert, Chart on the Designer menu or click the Chart button. A sample chart is displayed in the Chart View dialog box.
Click here to see a screenshot
The Chart View is displayed.
You can now design the chart using the Wizard or the Chart Editor.
The Chart View dialog box can also be opened by double-clicking over the chart in Design or Query mode.
Right-click on the Chart View dialog box in Design mode for further options including modifying chart data and saving the chart to a file. Open the dialog box in Query mode to display drill options.
|
Vision Exec 
