Edilitics | Data to Decisions

Funnel Chart

Show a single process narrowing stage by stage, with each slice's width proportional to its value. Best for conversion funnels and pipeline drop-off.

A funnel chart shows a single process moving through ordered stages, drawn as stacked slices that narrow from top to bottom. Drop exactly one categorical or date field into Column - its values become the stages - and exactly one numeric field into Row to set each slice's width. Use it when the story is a single process losing volume at each step, not a branching flow between two open-ended sets of values.

When to Use

A funnel chart answers "where in this process are we losing the most" - a sales pipeline narrowing from leads to closed deals, a signup flow narrowing from visits to activated accounts, a hiring process narrowing from applicants to offers. The visual shrinkage between consecutive slices is the entire point: a big drop between two stages is immediately visible as a sharp narrowing, while a healthy stage shows almost no shrinkage at all.

The funnel's shape comes from the chart's Sort setting, not a rule built into this chart type. By default, the chart-wide sort orders the measure in descending order, which is exactly what produces a properly narrowing funnel. If that sort is changed to ascending or turned off, the slices will follow that order instead - the funnel chart itself has no independent "always biggest on top" logic.

Switch to a different chart when:

  • Your flows branch or merge between two open-ended sets of values, not a strict single sequence - use a Sankey Diagram
  • You need exact stage values in a list, not a visual narrowing shape - use Text Table
  • You're comparing totals across categories with no inherent sequence or drop-off - use Horizontal Bar
ScenarioStage Field (Column)Value (Row)
Sales pipeline conversionPipeline stageDeal count
Signup flow drop-offFunnel stepUser count
Hiring process narrowingRecruitment stageCandidate count
Email campaign engagementEngagement stepRecipient count
Support ticket resolution stagesTicket statusTicket count

Required Inputs

FieldTypeCount
Dimension (Stages)Categorical or DateExactly 1
Measure (Slice width)NumericExactly 1

For step-by-step build instructions, see Build Your First Chart.

Formatting Options

The Format tab unlocks after both fields are assigned.

Style

Use the chart title to state what process the funnel is tracking, since stage names alone don't always make the sequence obvious.

ControlWhat it does
Show Chart TitleShows or hides the title.
Enter Chart TitleTitle text. Maximum 50 characters.
Font familyFont applied to the title.
Font size5 to 30.
Bold / ItalicWeight and style.
AlignmentLeft, center, or right within the chart container.

Funnel Series is a small, focused panel - just the two structural controls beyond width that this chart type exposes.

ControlWhat it does
AlignLeft, center, or right. How each slice aligns relative to the funnel's centerline.
GapPixel spacing between consecutive slices.

Funnel Layout has a single control: how wide the funnel is within its chart area.

ControlWhat it does
Width (%)10 to 100. How much of the chart's horizontal space the funnel occupies.

Despite the name, this panel only controls data labels - there is no per-slice color, border, or opacity control anywhere in the formatting options. Slice colors are generated automatically from your chart-wide palette.

ControlWhat it does
Show Data LabelsShows or hides labels on each slice. Off by default. By itself, this only adds the stage name - it does not show the number.
Show ValuesShows the slice's value alongside its name. On by default once Show Data Labels is enabled.
Number TypeDefault, Scientific, Decimal, or Percentage, for the value shown.
Display UnitNone, Thousand, Million, or Billion.
Show PercentageShows what percentage of the largest stage's value this slice represents.
Font Family / Color / Font size / Bold / ItalicStyling for the label text.
Label PositionInside, Center, Inside Left, Inside Right, or Outside, relative to the slice.

Show Data Labels and Show Values are separate toggles. If a funnel shows only stage names with no numbers, check that Show Values (or Show Percentage) is also on - Show Data Labels alone only adds the name.

The legend lists each stage by name, useful when slice labels are turned off or when stage names are long enough to be easier to read in a list.

ControlWhat it does
Show LegendsShows or hides the legend entirely.
Vertical Position / Horizontal PositionWhere the legend sits within the chart area.
Show NameDefault (always visible) or On Hover (names appear only while hovering a slice). Defaults to On Hover.
OrientationHorizontal or vertical layout of legend items.
Item GapSpacing between legend entries.
Font Size / ColorStyling for the legend text.

Interactivity

The tooltip appears on hover over a slice, showing the stage name and its value, with an optional percentage.

ControlWhat it does
Show TooltipShows or hides the tooltip entirely.
Show PercentageAdds a percentage line to the tooltip, alongside the name and value lines.
Header / value text stylingFont, size, and color for the lines shown in the tooltip.

Animation controls the slices' transition when the chart first renders or the data changes.

ControlWhat it does
Enable AnimationTurns the transition animation on or off.
DurationHow long the transition takes.
DelayHow long the transition waits before starting.
Easing FunctionThe transition curve.

Emphasis controls the visual response when hovering a slice - a scale-up effect and a drop shadow. Off by default.

ControlWhat it does
Show EmphasisTurns hover effects on.
Focus TypeItem, Series, or None.
Enable ScaleScales the hovered slice up slightly.
Scale Size1.0x to 2.0x.
Shadow Blur / Color / Offset X / Offset YDrop shadow styling on the hovered slice.
Border WidthBorder added around the hovered slice.

Enable the Toolbox when viewers need to export the chart or inspect its underlying data.

ControlWhat it does
Show ToolboxShows or hides the toolbox icon bar.
Save as ImageAdds a download icon that saves the chart as a PNG.
Data ViewAdds an icon that opens the underlying data table in a separate view.

Best Practices

Check the chart's Sort setting if the funnel doesn't look right. A funnel chart has no built-in "always descending" rule of its own - it inherits whatever sort order the chart is currently using. If a funnel looks inverted or jumbled, the fix is in Sort, not in any funnel-specific setting.

Turn on Show Values, not just Show Data Labels, if you want numbers visible. These are two separate toggles. Show Data Labels alone only prints the stage name on each slice.

Use Show Percentage to make drop-off immediately readable. A percentage relative to the top stage communicates conversion rate at a glance, which raw counts alone require the viewer to calculate themselves.

Don't expect per-slice color control - plan palette colors at the chart level instead. Since slice colors come entirely from the chart-wide palette gradient, the way to control which stage gets which shade is by adjusting Start/End palette colors in chart-wide color settings, not in this chart's own formatting panel.

Reserve funnel charts for genuinely linear, single-path processes. If stages can branch, merge, or loop back, a funnel chart will force that data into a shape that misrepresents it - a Sankey Diagram handles branching flows correctly where a funnel cannot.

FAQs

Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.

Last updated on

On this page