Funnel_Chart
Funnel_Chart
Funnel_Chart
Funnel charts are generally used to view and analyze a measure e.g: Sales, Profit across
various stages, segments, categories or partitions in the data
Given below are the 3 things that can be observed in a Funnel Chart:
2. Size of the different boxes i.e., bigger the size of the box the bigger is the measure
3. Each category or segment will have a different color. Categorical color palette is assigned
to the categories, stages or segments
FUNNEL CHARTS
A funnel chart is a specialized chart type that is typically used to display the flow of users
through a business or sales process.
The chart gets its name from its shape, which starts from a broad head and ends in a narrow
neck.
The number of items at each stage of the process are indicated from the funnel’s width as it
narrows.
STEP 7: Right-click Profit, Select Quick Table Calculation > Percent of Total
STEPS TO CREATE A BASIC FUNNEL CHART
STEP 8: Drag and drop Ship Mode to the Label on Marks card of SUM(Neg Sales)
STEPS TO CREATE THE ADVANCED FUNNEL CHART
STEP 9: Drag and drop Sales to the Label on Marks card of SUM(Sales)
STEPS TO CREATE THE ADVANCED FUNNEL CHART
STEP 10: Right-click Sales, Select Quick Table Calculation > Percent of Total
STEPS TO CREATE THE ADVANCED FUNNEL CHART
STEP 11: If required we can change the color of the chart for SUM(Sales)
and SUM(Neg Sales)
STEPS TO CREATE A BASIC FUNNEL CHART