SharePoint components - business processes without development, InfoPath, SharePoint Designer or workflows. SharePoint Services, SharePoint Foundation & SharePoint Server 2010-2016.

Training

Event Calendar

Funnel Chart

A Funnel Chart is often used to show a reductive process in which there are smaller quantities over the progression of a process. In particular this is useful for sales data. Consider this chart which indicates the progression from prospective customers to converted sales:

Instructions

  • Begin by creating appropriate list data for a Funnel Chart.
  • Create a new custom list using Sales Stage, Index and Total columns.
  • Rename the Title column to Sales Stage for this list.
  • Add in some test data similar to below in which the values decrease for each successive record.

  • Create a new SharePoint wiki page called Sales Conversion Chart.
  • Add in a Smart Chart web part as described on the Column Chart page.
  • Set Sales Stage to be used for the Category.
  • Use the Total column with the Sum setting for the Series.
  • Use the Show Values option with this chart.

Summary

A Funnel Chart typically only fits a very specific type of data set. Consider this type of chart when demonstrating progression toward a goal via a process of elimination.

Last modified: 8/24/2015 5:34 PM
Be the first to add a comment to this article
 
Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.