28.1.4 The 2D Graphs Toolbar

2D Graphs bar.png

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 the button Button Expand FO Edit Box.png to the right of the toolbar button is clicked. The last button, Button Template Library.png, 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.
Button Line.png

Plots selected data as a Line graph.

Button Horizontal Step.png

Plots selected data as a Horizontal Step graph.

Button Vertical Step.png

Plots selected data as a Vertical Step graph.

Button Spline Connected.png

Plots selected data with a Spline connection.

Button Scatter.png

Plots selected data as a Scatter Graph.

Button Grouped Scatter-Indexed Data.png

Plots selected data as a Grouped Scatter - Indexed Data graph.

Button Scatter central.png

Plots selected data as a Scatter Central graph.

2dgraph extended toolbar colscatter 92.png

Plots selected data as a Column Scatter.

Button Y Error.png

Plots selected data with Y error bars.

Button X Y Error.png

Plots selected data with X and Y error bars.

Button Vertical Drop Line.png

Plots selected data with vertical drop lines.

Button Bubble.png

Plots selected data as a Bubble graph.

Button Color Map.png

Plots selected data as a Color Map graph.

Button Bubble And Color Mapped.png

Plots selected data as a Bubble and Color Map graph.

Button Line And Symbol.png

Plots selected data as a Line and Symbol graph.

Button Line Series.png

Plots selected worksheet columns as a Line Series graph.

Button 2 Point Segment.png

Plots selected data as a 2 points Segment graph.

Button 3 Point Segment.png

Plots selected data as a 3 points Segment graph.

Button Row-wise.png

Plots a shared "X" row and one or more "Y" rows as a grouped Line + Symbol plot. See Row Wise Graph.

Button Column.png

Plots selected data as a Vertical Column graph.

Button Column Label.png

Plots selected data as a Column and Label graph.

Button Grouped Column-Indexed Data.png

Plots selected data as a Grouped Column with Indexed Data.

Button Bar.png

Plots selected data as a Horizontal Bar graph.

Button Stack Column.png

Plots selected data as a Vertical 100% Stacked Column graph.

Button 100p Stacked Column.png

Plots selected data as a Horizontal 100% Stacked Bar graph.

Button 100p Stacked Bar.png

Plots selected data as a Horizontal Stacked Bar graph.

Button Stack Bar.png

Plots selected data as a Horizontal Stacked Bar graph.

Button Floating Column.png

Plots 2 selected worksheet Y columns as a Floating Column graph.

Button Floating Bar.png

Plots 2 selected worksheet Y columns as a Floating Bar graph.

Button Pie Chart.png

Plots selected worksheet Y column as a colored 3 dimensional Pie Chart.

Button B&W Pie Chart.png

Plots selected worksheet Y column as a black and white 2 dimensional Pie Chart.

Button Double Y Axis.png

Plots 2 selected worksheet Y columns as a Double Y Axis graph.

Button 3Ys Y-YY.png

Plots 3 selected worksheet Y columns as a Double Y graph with Righthand Y Offset Axis.

Button 3Ys Y-Y-Y.png

Plots 3 selected worksheet Y columns as a Double Y graph with Center Y Offset Axis.

Button 4Ys Y-YYY.png

Plots 4 selected worksheet Y columns as a Double Y graph with two Righthand Y Offset Axis.

Button 4Ys YY-YY.png

Plots 4 selected worksheet Y columns as a Double Y graph with Double Y Offset Axis.

Button Multiple Y Axes.png

Plots selected worksheet Y columns as a multiple Y Axes graph.

Button Stack Lines By Y Offsets.png

Plots selected worksheet columns as line plots with offsets so they stack on top of each other.

Button Colormapped Line Series.png

Plots selected worksheet columns as a Colormapped Line Series plot (a flattened 2D waterfall with a colormap applied to Z values).

Button Waterfall.png

Plots selected worksheet columns as a Waterfall graph.

Button Waterfall Y Color Mapping.png

Plots selected worksheet columns as a Waterfall Y Color Mapping.

Button Waterfall Z Color Mapping.png

Plots selected worksheet columns as a Waterfall Z Color Mapping.

Button 3D Waterfall.png

Plots selected worksheet columns as a 3D Waterfall.

Button 3D Y Color Mapping.png

Plots selected worksheet columns as a 3D Waterfall with Y Color Mapping.

Button 3D Z Color Mapping.png

Plots selected worksheet columns as a 3D Waterfall with Z Color Mapping.

Button Vertical 2 Panel.png

Plots selected data into a 2 Paneled Vertical template.

Button Horizontal 2 Panel.png

Plots selected data into a 2 Paneled Horizontal template.

Button 4 Panel.png

Plots selected data into a 4 Paneled template.

Button 9 Panel.png

Plots selected data into a Paneled template.

Button Stack.png

Plots each database in a separate layer using a Stack template.

Button Multiple Panels.png

Plots a multi-layer graph by grouping column labels.

Button Box Chart.png

Plots selected data as a Box Chart.

Button Violin-Box.png

Plots selected data as a Violin with Box.

Button Interval Plot.png

Plots selected data as an Interval Plot.

Button Grouped Box-Indexed Data.png

Plots selected indexed data as a Grouped Box Chart.

Button Grouped Box-Row Data.png

Plots selected raw data as a Grouped Box Chart.

Button Histogram.png

Plots selected Y columns as histogram.

Button Histogram And Probabilities.png

Plots histogram for selected worksheet columns and creates a Cumulative Count graph.

Button Stacked Histograms.png

Plots selected data into Stacked histograms.

Button Marginal Histograms Graph.png

Plots selected two datasets as a Marginal Histograms Graph.

Button Marginal Boxes Graph.png

Plots 2 selected datasets as a Marginal Box Chart.

Button 2D Kernel Density.png

Plots selected single Y column or XY column as 2D Kernel Density Plot.

Button X Bar And R Chart.png

Plots selected worksheet columns as a QC Chart.

Button Pareto Chart-Binned Data.png

Plots selected worksheet columns as a Pareto Binned Chart.

Button Pareto Chart-Raw Data.png

Plots selected worksheet columns as a Pareto Raw Data Chart.

Button Scatter Matrix.png

Plots selected data as a Scatter Matrixsheet.

Button Probability Plot.png

Plots selected worksheet columns as a Probability graph.

Button Q-Q Plot.png

Plot selected worksheet columns as a Q-Q graph.

Button Stack Area.png

Plots selected data as an Area graph.

Button Area.png

Plots selected data as a Stacked Area graph.

Button Fill Area.png

Plots 2 selected worksheet columns as a Filled Area graph.

Button Polar Theta R.png

Plots selected worksheet columns as a Polar graph theta(X) and r(Y).

Button Polar R Theta.png

Plots selected worksheet columns as a Polar graph r(X) and theta(Y).

Button Wind Rose-Binned Data.png

Plots selected worksheet columns as a Wind Rose Binned graph.

Button Wind Rose-Raw Data.png

Plots selected columns as a Wind Rose Raw Data graph.

Button Ternary.png

Plots selected data as a Ternary graph.

Button Piper.png

Plots selected data as a Piper graph.

Button Smith Chart.png

Plots selected worksheet columns as a Smith Chart graph.

Button Radar.png

Plots selected data as a Radar graph.

Button Vector XYAM.png

Plots 3 selected worksheet Y columns as a Vector XYAM graph.

Button Vector XYXY.png

Plots 4 selected worksheet column as a Vector XYXY graph.

Button Zoom.png

Plots selected data into a Zoom template.

Button High Low Close.png

Plots 3 selected worksheet Y columns as a High-Low-Close graph.

Button Japanese Candlestick.png

Plots selected data with Japanese Candlestick.

Button OHLC Bar Chart.png

Plots selected data with OHLC Bar Chart.

Button OHLC-volume.png

Plots selected data with OHLC-volume.

Button Stock Line.png

Plots selected data with Line (adapted for charting stocks).

Button Template Library.png

Opens the Template Library.

English | Deutsch | 日本語