|Charting | Chart Builder ||
This panel allows the user to select the chart type, specify chart-specific settings (including the columns of data to be plotted), and enable chart interactions.
The Chart Parameters panel appears on the left side of the Chart Builder next to the Data Columns panel.
The Select Chart section allows you to choose the type of chart you would like to create.
If you select a particular chart type from the Chart menu of an open table or worksheet, the Chart Builder is displayed with that chart type highlighted in red, indicating it is selected.
The Chart Builder can suggest types of charts based on the data you want to plot.
You can drag columns from the Data Columns panel into the corresponding Drop column box for each axis. The Chart Builder will highlight suggested chart types in blue in the Select Chart section. When you select a particular chart type, it will be highlighted in red.
For example, if you specify columns for the X-axis and Y-axis, the Chart Builder will suggest chart types that typically require two variables, such as a Line chart or a Bar chart. If you also specify a column for the Z-axis, chart types that typically require three variables, such as a Scatter (3D) or Surface chart, would be highlighted.
Or, if you know the type of chart you want, simply select that chart type in the Select Chart section.
Once a chart type is selected, settings related to that particular chart type will appear in the Settings section, and Drop column boxes will be provided in separate Data sections for the data required to plot the selected chart type.
The Settings section displays a number of general parameters related to the chart, such as the number of samples to include in the chart or whether to use a linear or logarithmic scale for a particular axis.
It also displays settings that are specific to the chart type selected in the Select Chart section. For instance, if you select a Bar chart, you will see settings for Bar orientation and Layout.
See Chart Settings for a detailed listing of the general and chart-specific parameters that may appear under the Settings section.
One or more Data sections are provided, depending on the type of chart selected in the Select Chart section. The parenthetical text within each of the Data headings gives an indication of how that data will be plotted for the selected chart type.
You can drag and drop the columns from the Data Columns panel into the Drop column boxes in these sections so that the data from those columns is plotted accordingly in the chart.
Chart interactions allow you to zoom in or out of the current chart. You can also center the chart around a certain point by double-clicking in the desired spot on the chart.
Once chart interactions are enabled, you can perform the following mouse actions on the current chart:
|Double-click||Double-click at a particular spot on a chart to center the chart at that location.|
|Drag||Drag the pointer over an area to zoom into the corresponding rectangular region.|
|Wheel Up||Rotate the wheel button forward to zoom out of the chart.|
|Wheel Down||Rotate the wheel button backward to zoom in to the chart.|