1.128 FAQ-715 What are the unsupported graph types when open Excel workbook in Origin to plot?

Last Update: 4/9/2021

Origin's creates a between your Origin project and an external Excel file, making it easy to work with Excel files without opening them in Origin. If you are accustomed to opening your Excel files in Origin and you are upgrading to Origin 2021b or later, please see .

When you "Open" an Excel file in Origin workspace you have limited use of Origin's graphing capabilities. When making plots using the dialog, you can designate multiple columns as Y (Y denotes the ) but you can only select one column as X or Z.

Each in Origin requires a certain combination of . Some graph types requires additional label row or error columns as input. Others need to plot from a matrix stored in Origin matrixbook or a virtual matrix stored in an Origin worksheet. For a synopsis of data requirements by plot type, see .

Graph types and can be plotted if you click Use Defaults button once in the dialog to use .

The table below lists all the unsupported graph types if you to plot:

2D, Contour and Image Profiles

Graph Type	Access Menu
	Plot > Multi-Panel/Axis : Multiple Panels by Label (Worksheet Data)
	Plot > Categorical: Grouped Box Charts - Raw Data (Worksheet Data)
	Plot > Contour : Heatmap (Worksheet/Matrix Data)
	Plot > Contour: Ternary Contour (Worksheet Data)
	Plot > Contour : Image Plot (Matrix Data)
	Plot > Contour : Image Profiles (Worksheet/Matrix Data)

3D Surface

Graph Type	Access Menu
	Plot > 3D : 3D X Constant with Base (Worksheet/Matrix Data)
	Plot > 3D : 3D Y Constant with Base (Worksheet/Matrix Data)
	Plot > 3D : Color Map Surface with Projection (Worksheet/Matrix Data)
	Plot > 3D : 3D Ternary Colormap Surface (Worksheet Data)
	Plot > 3D : Color Fill Surface with Error Bar (Matrix Data)
	Plot > 3D : Multiple Color Fill Surfaces (Matrix Data)
	Plot > 3D : Multiple Color Map Surfaces (Matrix Data)