This new feature is available for Office 365 subscribers.

  1. Select your data in Excel. It should have a row for each stage of the process and a column for the values.
  2. Click the Insert tab.
  3. Click Insert Waterfall or Stock Chart > Funnel. Excel will insert the funnel chart for you. Double-click in the chart to format the bars and other design elements of the funnel chart, or go to the Design and Format tabs to quickly customize the chart’s appearance.

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special