30.1.4 The 2D Graphs Toolbar

The 2D Graphs toolbar buttons are available when a worksheet, Excel workbook, or graph window is active. Buttons provide quick access to common 2D graph templates. Related plot types are grouped and can be accessed from a popup menu when click the triangle ⯆ to the right of the button. The last button, , opens the Template Library, providing access to custom graph templates.

To use the 2D Graphs toolbar buttons:

When a worksheet or Excel workbook is active, highlight the data to be plotted, and click the appropriate button on the 2D Graphs toolbar to create a graph.

When a graph window is active, the graph type can be changed (for example, from a scatter plot to a column plot) for the active data plot.

	Plots selected data as a Line graph.
	Plots selected data as a Horizontal Step graph.
	Plots selected data as a Vertical Step graph.
	Plots selected data with a Spline connection.
	Plots selected data as a Scatter Graph.
	Plots selected data as a Grouped Scatter - Indexed Data graph.
	Plots selected data as a Scatter Central graph.
	Plots selected data as a Column Scatter.
	Plots selected data with Y error bars.
	Plots selected data with X and Y error bars.
	Plots selected data with vertical drop lines.
	Plots selected data as a Bubble graph.
	Plots selected data as a Color Map graph.
	Plots selected data as a Bubble and Color Map graph.
	Plots selected data as a Line and Symbol graph.
	Plots selected worksheet columns as a Line Series graph.
	Plots selected data as a 2 points Segment graph.
	Plots selected data as a 3 points Segment graph.
	Plots a shared "X" row and one or more "Y" rows as a grouped Line + Symbol plot. See Row Wise Graph.
	Plots selected data as a Vertical Column graph.
	Plots selected data as a Column and Label graph.
	Plots selected data as a Grouped Column with Indexed Data.
	Plots selected data as a Horizontal Bar graph.
	Plots selected data as a Vertical 100% Stacked Column graph.
	Plots selected data as a Horizontal 100% Stacked Bar graph.
	Plots selected data as a Horizontal Stacked Bar graph.
	Plots selected data as a Horizontal Stacked Bar graph.
	Plots 2 selected worksheet Y columns as a Floating Column graph.
	Plots 2 selected worksheet Y columns as a Floating Bar graph.
	Plots selected worksheet Y column as a colored 3 dimensional Pie Chart.
	Plots selected worksheet Y column as a black and white 2 dimensional Pie Chart.
	Plots 2 selected worksheet Y columns as a Double Y Axis graph.
	Plots 3 selected worksheet Y columns as a Double Y graph with Righthand Y Offset Axis.
	Plots 3 selected worksheet Y columns as a Double Y graph with Center Y Offset Axis.
	Plots 4 selected worksheet Y columns as a Double Y graph with two Righthand Y Offset Axis.
	Plots 4 selected worksheet Y columns as a Double Y graph with Double Y Offset Axis.
	Plots selected worksheet Y columns as a multiple Y Axes graph.
	Plots selected worksheet columns as line plots with offsets so they stack on top of each other.
	Plots selected worksheet columns as a Colormapped Line Series plot (a flattened 2D waterfall with a colormap applied to Z values).
	Plots selected worksheet columns as a Waterfall graph.
	Plots selected worksheet columns as a Waterfall Y Color Mapping.
	Plots selected worksheet columns as a Waterfall Z Color Mapping.
	Plots selected worksheet columns as a 3D Waterfall.
	Plots selected worksheet columns as a 3D Waterfall with Y Color Mapping.
	Plots selected worksheet columns as a 3D Waterfall with Z Color Mapping.
	Plots selected data into a 2 Paneled Vertical template.
	Plots selected data into a 2 Paneled Horizontal template.
	Plots selected data into a 4 Paneled template.
	Plots selected data into a Paneled template.
	Plots each database in a separate layer using a Stack template.
	Plots a multi-layer graph by grouping column labels.
	Plots selected data as a Box Chart.
	Plots selected data as a Violin with Box.
	Plots selected data as an Interval Plot.
	Plots selected indexed data as a Grouped Box Chart.
	Plots selected raw data as a Grouped Box Chart.
	Plots selected Y columns as histogram.
	Plots histogram for selected worksheet columns and creates a Cumulative Count graph.
	Plots selected data into Stacked histograms.
	Plots selected two datasets as a Marginal Histograms Graph.
	Plots 2 selected datasets as a Marginal Box Chart.
	Plots selected single Y column or XY column as 2D Kernel Density Plot.
	Plots selected worksheet columns as a QC Chart.
	Plots selected worksheet columns as a Pareto Binned Chart.
	Plots selected worksheet columns as a Pareto Raw Data Chart.
	Plots selected data as a Scatter Matrixsheet.
	Plots selected worksheet columns as a Probability graph.
	Plot selected worksheet columns as a Q-Q graph.
	Plots selected data as an Area graph.
	Plots selected data as a Stacked Area graph.
	Plots 2 selected worksheet columns as a Filled Area graph.
	Plots selected worksheet columns as a Polar graph theta(X) and r(Y).
	Plots selected worksheet columns as a Polar graph r(X) and theta(Y).
	Plots selected worksheet columns as a Wind Rose Binned graph.
	Plots selected columns as a Wind Rose Raw Data graph.
	Plots selected data as a Ternary graph.
	Plots selected data as a Piper graph.
	Plots selected worksheet columns as a Smith Chart graph.
	Plots selected data as a Radar graph.
	Plots 3 selected worksheet Y columns as a Vector XYAM graph.
	Plots 4 selected worksheet column as a Vector XYXY graph.
	Plots selected data into a Zoom template.
	Plots 3 selected worksheet Y columns as a High-Low-Close graph.
	Plots selected data with Japanese Candlestick.
	Plots selected data with OHLC Bar Chart.
	Plots selected data with OHLC-volume.
	Plots selected data with Line (adapted for charting stocks).
	Opens the Graph Maker dialog.
	Opens the Template Library.